Skip to Main Content

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!

Clearing out global temporary tables in a session.

614849Apr 30 2008 — edited Apr 30 2008
I have a global temporary table that is used within one stored procedure. Another procedure calls it twice in succession and the second time the child SP is called, the temp table is retaining the values from the first call. I want to clear the contents of the temp table before the child SP completes, but am getting an "invalid table name" error when I try to truncate it or delete the contents. Any thoughts?

By the way, when I created the global temp table, I used 'on commit delete rows'

Thanks
Matt
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on May 28 2008
Added on Apr 30 2008
4 comments
1,324 views