RE: dynamic sql problem

From: Thomas, Kevin <Kevin.Thomas_at_calanais.com>
Date: Tue, 07 Aug 2001 01:37:05 -0700
Message-ID: <F001.00362633.20010807014105@fatcity.com>

Hi there,

It could just be that you are missing your semicolons ';' off the end of your statements.

Cheers,
Kev.

Kevin Thomas
Technical Analyst
Deregulation Services
Calanais Ltd.
Tel: 0141 568 2314
Fax: 0141 568 2366
http://www.calanais.com

-----Original Message-----
Sent: 06 August 2001 21:57
To: Multiple recipients of list ORACLE-L

HI,

I am running a stored procdures which contains following dynamic sql ..i am getting error:
ORA-00936 missing expression......... for the bold statement while rest of statements r properly executing......
what might be the reason......
and temp_ are variables declared...... and name1,name2,name3 are dynamically generated table names..........

str := 'alter table'||' '||name2||' '||'disable constraint'||' '||temp1_cons;
execute immediate str;
str := 'alter table'||' '||name3||' '||'disable constraint'||' '||temp_cons; execute immediate str;
str :='update '||' '||name2||' '||' set id_sess=id_sess + '||' '||temp_id_sess_2;
execute immediate str;
str :='update '||' '||name3||' '||' set id_sess = id_sess +'||' '||temp_id_sess_3;
execute immediate str;
str :='create table'||' '||enum||' '||'as select * from'||' '||name1||' '||'union
select * from'||' '||name2||' '||'union select * from'||' '||name3; execute immediate str;

Thanks
Harvinder
--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Harvinder Singh
INET: Harvinder.Singh_at_MetraTech.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Thomas, Kevin
INET: Kevin.Thomas_at_calanais.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------