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: Q: where can I find sql for a procedure in memory ?

Re: Q: where can I find sql for a procedure in memory ?

From: dave mausner <dmausner_at_ameritech.x.net>
Date: Tue, 11 Jan 2000 05:59:40 GMT
Message-ID: <8EB7F1377dlm@206.141.192.241> 





tedchyn_at_yahoo.com wrote in <85dm3d$s2v$1_at_nnrp1.deja.com>:



>Sir,


> Is it true pl/sql procedures are preparsed therefore the sql will not


>appear in sql area ?





pl/sql is compiled into internal codes (apparently called "diana") which 
cannot be viewed, but even embedded SQL can be viewed while a procedure, 
function, or trigger is running.


-- 


dave mausner
Received on Mon Jan 10 2000 - 23:59:40 CST












Original text of this message













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