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

Home -> Community -> Usenet -> c.d.o.misc -> prepare procedure

prepare procedure

From: Erik Ulven <erik_at_quasar.no>
Date: Wed, 17 Nov 1999 10:50:44 GMT
Message-ID: <3832877E.D9ED9812@quasar.no> 





Hello,



I wonder if there is possible to prepare a procedure before running it.
We use a pretty heavy procedure, and it uses a long time on first run,
but the next run it uses almost half the time. In delphi I used to call
prepare before calling procedures, but how can i do this in oracle sql?



Best regards,



Erik






Received on Wed Nov 17 1999 - 04:50:44 CST












Original text of this message













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