Oracle Database Discussions

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!

sp_executesql & temporary tables

209882May 22 2002

Hi,

Trying to migrate from SQLServer2000, some of the procedure use the "sp_executesql" keyword...
How could I translate it in Oracle ?

I have also temporary tables created in some procedure...
is there a way (a buffer, table datatype,?...) to produce the same effect in Oracle but (temporary storage) but without creating tables physically ?

Thanks a lot.
Fabien

Locked Post

New comments cannot be posted to this locked post.

Locked on Jun 20 2002

Added on May 22 2002

#database-and-application-migrations

2 comments

3,153 views