IT Employment



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.

Thread display: Collapse - | Expand +

All Answers

Related Discussions

Related Forums