exec immediate 2006-01-24 - By raja rao
the below did work fine:
declare
x varchar2(100);
begin
execute immediate 'select hospital_id||to_char(trnx_date,'||'''||mmddyyyy||'''|
|')||patient_case_type from SJHS_ADT_ACT_TRXMST_BAK2 ' into x;
dbms_output.put_line(x);
end;
this executed successfully with teh MMDDYYYY format however, the result seems
to
be strage with a single pipe:
The result is:
SJHS|09102004|ER
Actually the pipe should not be there, it should be: SJHS09102004ER
what couldbe the reason.
David Sharples <davidsharples@(protected)> wrote:
the semi colon goes after the final ' in the statement.
Plus that query is a little silly anyway
On 1/24/06, raja rao <raja4list@(protected)> wrote:
when the below is run i am getting the error. can someone help me :
begin
execute immediate ' select sysdate from dual ;'
end ;
-- ---- ---- ---- ---- ---- -----
Yahoo! Photos
Ring in the New Year with Photo Calendars. Add photos, events, holidays,
whatever.
<DIV> </DIV> <DIV>the below did work fine:</DIV> <DIV> </DIV> <DIV
>declare<BR>x varchar2(100);</DIV> <DIV>begin<BR>execute immediate 'select
hospital_id||to_char(trnx_date,'||'''||mmddyyyy||'''||')||patient_case_type
from SJHS_ADT_ACT_TRXMST_BAK2 ' into x;<BR>dbms_output.put_line(x);</DIV>
<DIV>end;<BR></DIV> <DIV> </DIV> <DIV> </DIV> <DIV>this executed
successfully with teh MMDDYYYY format however, the result seems to</DIV> <DIV
>be strage with a single pipe:</DIV> <DIV> </DIV> <DIV>The result is:<
/DIV> <DIV> </DIV> <DIV>SJHS|09102004|ER<BR></DIV> <DIV> </DIV>
<DIV>Actually the pipe should not be there, it should be: SJHS09102004ER</DIV>
<DIV> </DIV> <DIV>what couldbe the reason.<BR><BR><BR><B><I>David Sharples
<davidsharples@(protected)></I></B> wrote:</DIV> <BLOCKQUOTE class=replbq
style="PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #1010ff 2px solid">
<DIV>the semi colon goes after the final ' in the
statement.</DIV> <DIV> </DIV> <DIV>Plus that query is a little silly
anyway<BR><BR> </DIV> <DIV><SPAN class=gmail_quote>On 1/24/06, <B class
=gmail_sendername>raja rao</B> <<A onclick="return top.js.OpenExtLink(window
,event,this)" href="mailto:raja4list@(protected)" target=_blank>raja4list@(protected)
.com</A>> wrote: </SPAN> <BLOCKQUOTE class=gmail_quote style="PADDING-LEFT:
1ex; MARGIN: 0px 0px 0px 0.8ex; BORDER-LEFT: #ccc 1px solid"> <DIV> </DIV
> <DIV>when the below is run i am getting the error. can someone help me :</DIV
> <DIV> </DIV> <DIV>begin<BR>execute immediate ' select sysdate
from dual ;'<BR>end ;</DIV> <DIV> </DIV></BLOCKQUOTE></DIV></BLOCKQUOTE>
<DIV><BR></DIV><p>
<hr size=1>Yahoo! Photos<br>
Ring in the New Year with <a href="http://us.rd.yahoo.com/mail_us/taglines
/photos/*http://pa.yahoo.com/*http://us.rd.yahoo.com/mail_us/taglines/photos/evt
=38087/*http://pg.photos.yahoo.com/ph//page?.file=calendar_splash.html&.dir="
>Photo Calendars</a>. Add photos, events, holidays, whatever.
|
|
