Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Stuck on insert into a global temporary table

Re: Stuck on insert into a global temporary table

From: Martin Haltmayer <Martin.Haltmayer_at_0800-einwahl.de>
Date: Sun, 07 Jan 2001 15:23:30 +0100
Message-ID: <3A587BE2.CDC72B20@0800-einwahl.de> 






Hello Roman,



    
  
  1.   Does the insert work in normal sqlplus?

  
  2.   If so, does it work in native dynamic sql in your packaged procedure?






There used to be a bug that SQL was a bit further in its version than PL/SQL. So
PL/SQL did not know how to handle global temporary tables but sql knew. The
workaround to this bug is using dynamic sql which forces sql to parse the code
instead of PL/SQL.



Martin
Received on Sun Jan 07 2001 - 08:23:30 CST












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US