Hi:
I have a question regarding the DBMS_SQL package provided through the
Oracle 7 server; we have Oracle 7.3 currently installed on an HP-UX 3000
server and we've been experimenting with stored procedures which make
use of the DBMS_SQL package [which we call from an Oracle 4.5 Forms
app]. In our code, we are passing SQL DDL statements into the stored
procedure for execution & commit. It appears that the only way we can
successfully execute these procedures is if the stored procedure is
stored under the SYS owner. Does anyone know of a way to store the
procedure under a userspace while designing/debugging so that the code
could be executed successfully from the userspace without having to port
it to the SYS owner?
--
Michael Rosadino
E-mail(W): mrosadino_at_ggtinc.com
Work: (860)871-8082, x3484
Received on Wed Mar 18 1998 - 00:00:00 CST
