SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

ORA-06543 ?

lzhwxyMay 16 2004 — edited May 16 2004

I use following statement to create a temporary table in a procedure:
execute immediate 'CREATE GLOBAL TEMPORARY TABLE tablename (column1 NUMBER,column2 NUMBER) ON COMMIT delete ROWS';

when I ran the whole batch of procs, it worked fine, but when I tried to debug it in Rapid SQL, each time when I step over this statement, I got a ORA-06543 error.

Anyone has any ideas about this issue?

Locked Post

New comments cannot be posted to this locked post.

Locked on Jun 13 2004

Added on May 16 2004

3 comments

1,955 views