exec immediate 2006-01-24 - By raja rao
I am sorry for that.
tensed because of the dead line.
Sorry for the trouble. I am able to made it finally.
I apologize everyone for the inconvenience.
Carel-Jan Engel <cjpengel.dbalert@(protected)> wrote:
Raja,
A major reason might be that you actually (probably) do not understand
what you're doing. Please read some fine manuals, and refrein from
(ab)using this forum as a tutorial.
Regards, Carel-Jan
===
If you think education is expensive, try ignorance. (Derek Bok)
===
>
> 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 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 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.
--
http://www.freelists.org/webpage/oracle-l
-- ---- ---- ---- ---- ---- -----
Yahoo! Photos
Got holiday prints? See all the ways to get quality prints in your hands ASAP.
<DIV>I am sorry for that.</DIV> <DIV> </DIV> <DIV>tensed because of the
dead line.</DIV> <DIV> </DIV> <DIV>Sorry for the trouble. I am able to
made it finally.</DIV> <DIV> </DIV> <DIV>I apologize everyone for the
inconvenience.</DIV> <DIV><BR><BR><B><I>Carel-Jan Engel <cjpengel.dbalert
@(protected)></I></B> wrote:</DIV> <BLOCKQUOTE class=replbq style="PADDING
-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #1010ff 2px solid">Raja,<BR><BR>A
major reason might be that you actually (probably) do not understand<BR>what
you're doing. Please read some fine manuals, and refrein from<BR>(ab)using this
forum as a tutorial.<BR><BR>Regards, Carel-Jan<BR><BR>===<BR>If you think
education is expensive, try ignorance. (Derek Bok)<BR>===<BR><BR><BR><BR>>
<BR>> the below did work fine:<BR>><BR>> declare<BR>> x varchar2(100
);<BR>> begin<BR>> execute immediate 'select<BR>> hospital_id||to_char
(trnx_date,'||'''||mmddyyyy||'''||')||patient_case_type<BR>
>
from SJHS_ADT_ACT_TRXMST_BAK2 ' into x;<BR>> dbms_output.put_line(x);<BR>
> end;<BR>><BR>><BR>><BR>> this executed successfully with teh
MMDDYYYY format however, the result<BR>> seems to<BR>> be strage with a
single pipe:<BR>><BR>> The result is:<BR>><BR>> SJHS|09102004|ER<BR
>><BR>><BR>> Actually the pipe should not be there, it should be:
SJHS09102004ER<BR>><BR>> what couldbe the reason.<BR>><BR>><BR>>
David Sharples <DAVIDSHARPLES@(protected)>wrote:<BR>> the semi colon goes
after the final ' in the statement.<BR>><BR>> Plus that query is a little
silly anyway<BR>><BR>><BR>> On 1/24/06, raja rao <RAJA4LIST@(protected)
>wrote:<BR>> when the below is run i am getting the error. can someone help
me :<BR>><BR>> begin<BR>> execute immediate ' select sysdate from dual
;'<BR>> end ;<BR>><BR>><BR>><BR>><BR>><BR>><BR>> -- ---
-- ---- ---- ---- ---- ----<BR>> Yahoo! Photos<BR
>>
Ring in the New Year with Photo Calendars. Add photos, events, holidays,<BR>
> whatever.<BR><BR><BR>--<BR>http://www.freelists.org/webpage/oracle-l<BR><BR
><BR></BLOCKQUOTE> <DIV><BR></DIV><p>
<hr size=1>Yahoo! Photos<br>
Got holiday prints? <a href="http://us.rd.yahoo.com/mail_us/taglines
/holidayprints/*http://pa.yahoo.com/*http://us.rd.yahoo.com/mail_us/taglines
/photos/evt=38089/*http://pg.photos.yahoo.com/ph//print_splash">See all the ways
</a> to get quality prints in your hands ASAP.
|
|
