Re: Dynamic pl/sql
From: <rtproffitt_at_my-deja.com>
Date: Tue, 31 Aug 1999 20:31:05 GMT
Message-ID: <7qhe29$7c1$1_at_nnrp1.deja.com>
Date: Tue, 31 Aug 1999 20:31:05 GMT
Message-ID: <7qhe29$7c1$1_at_nnrp1.deja.com>
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 - 22:31:05 CEST