Home » SQL & PL/SQL » SQL & PL/SQL » ORA 08103 - object no longer exists referring a temporary table
ORA 08103 - object no longer exists referring a temporary table [message #683244] Fri, 18 December 2020 10:07 Go to next message
NZZ
Messages: 1
Registered: December 2020
Junior Member
Hi all,
I have a problem referring a Global Temporary Table.

I have created MyTempTable (ON COMMIT DELETE ROWS) and a procedure which populate it (MyProc).

Inside AnotherProc I call MyProc:

MyProc(); -- NO ERROR, MyTampTable contains rows
SELECT on MyTempTable -- NO ERROR
OPEN MyCursor FOR SELECT... -- ORA-08103

I tried to refer MyTampTable in every way (JOIN, WHERE x IN (...)), but I always get the error.

Any idea?
Re: ORA 08103 - object no longer exists referring a temporary table [message #683248 is a reply to message #683244] Fri, 18 December 2020 10:56 Go to previous message
Michel Cadot
Messages: 67850
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

Welcome to the forum.
Please read the OraFAQ Forum Guide and How to use [code] tags and make your code easier to read.
Indent the code, use code tags and align the columns in result.

You have to realize we can't know what was wrong if you don't show us what you do.
Use SQL*Plus and copy and paste your session, the WHOLE session.

Also always post your Oracle version, with 4 decimals (query v$version), as often solution depends on it.

Previous Topic: Insufficient privileges?
Next Topic: DBMS_HS_PASSTHROUGH - Column Value Truncated
Goto Forum:
  


Current Time: Fri May 14 11:55:47 CDT 2021