Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Dynamic pl/sql
Sounds like you would also need
'create or replace procedure x' priveledges.
I wonder if you could use the dynamic SQL
package to generate and compile the 'create or replace'
text...
Or perhaps you can model your problem into a whole series of smaller procs and functions which you could then stitch together for the desired result at runtime...similar to modeling a compiler where certain flags become whole sets of instructions for output....
Comments?
Robert Proffitt
Beckman Coulter
Sent via Deja.com http://www.deja.com/
Share what you know. Learn what you don't.
Received on Tue Aug 31 1999 - 15:31:05 CDT