This content has been marked as final. Show 2 replies
ORA-14450:attempt to access a transactional temp table already in use
Cause: An attempt was made to access a transactional temporary table that has been already populated by a concurrent transaction of the same session.
Action:do not attempt to access the temporary table until the concurrent transaction has committed or aborted.
I think if you post proc it will be best .
I have a stored procedure, sql is written like this:
insert into temptable xxxx;
select xx from temptable;
here temptable is a global temporary table.
there is nothing else about this temptable in my procedure, only the insert and select statement.
If that is really true then your stored procedure won't be valid and you can't even run it. Please post the actual procedure code.
You can't have a SELECT in a procedure with an INTO clause of some sort or the compiler will give you an error. Oracle has to have someplace to put the data.