PL/SQL (MOSC)

MOSC Banner

simple question: I am going to create the table

edited Aug 16, 2011 2:58AM in PL/SQL (MOSC) 6 commentsAnswered
Team

        I am trying to do the following in an Oracle stored procedure.
1 - rename MyTableName to TEMP_MyTableName
2 - create table MyTableName;
3 - Insert into MyTableName select * from TEMP_MyTableName;
4 - Drop table TEMP_MyTableName;

I am getting the following error for line 3
PL/SQL: ORA-00942: table or view does not exist

Since at the procedure creation time, TEMP_MyTableName does not exist.

Any way to go around this issue,

Thanks,

Hisham Awad

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center