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!

Creating a temp table dynamically

76046Dec 23 2001

Hi,

I was wondering if it is possible to create a temp table
dynamically, in Oracle 8.0, using DBMS_SQL or Execute_Immediate.
When I try to run a proc that should do it, I get a runtime
error. Can anyone tell me how I can do it?

Thanks in advance.

Sincerely,
Nikhil Kulkarni

Locked Post

New comments cannot be posted to this locked post.

Locked on Jan 21 2002

Added on Dec 23 2001

3 comments

1,338 views