Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> creating a stored procedure in a s.p.
hi,
following code does not work.
calling the stored procedure dag (call dag()) should
create or replace another stored procedure name mytest.
CREATE OR REPLACE PROCEDURE dag IS
BEGIN
EXECUTE IMMEDIATE 'CREATE OR REPLACE PROCEDURE mytest IS BEGIN INSERT
INTO dag_table values (1, 43); END;/';
END;
/
i log in as scott/tiger into sqlplus paste the procedure and start it. it quits with error ORA-01031: insufficient privileges.
creating the procedure dag, however, worked perfectly.
in case this does not work, is there another way to create a stored procedure from one a string (or set of string)?
thanx for your help,
edgar.
ps. please send a cc: by mail.
--
Edgar Weippl mailto:weippl_at_acm.org http://www.acm.org/~weipplPGP Fingerprint: F5FC 25AA 3AA1 7242 8F66 DD55 AFFE 0E46 F71E 571F Received on Wed Jan 12 2000 - 11:12:05 CST