How to create a stored proc that uses temp tables

By ratface ·
I am using pl/sql against an oracle database. I need to create a stored procedure that uses temp tables.

I found 'execute immediate' and used it for all of the DDL, for example,
execute immediate ' create table tempprimary' ... ;

The problem now is that my next statements are to populate the table:
insert into tempprimary
select distinct...

I get an error message that the table I just created does not exist.

Thanks in advance for your help.


This conversation is currently closed to new comments.

1 total post (Page 1 of 1)  
Thread display: Collapse - | Expand +

All Answers

Back to IT Employment Forum
1 total post (Page 1 of 1)  

Related Discussions

Related Forums