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 -> creating a stored procedure in a s.p.

creating a stored procedure in a s.p.

From: Edgar Weippl <weippl_at_acm.org>
Date: Wed, 12 Jan 2000 18:12:05 +0100
Message-ID: <387CB5E5.3AC9F7F0@acm.org>


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/~weippl

PGP Fingerprint: F5FC 25AA 3AA1 7242 8F66 DD55 AFFE 0E46 F71E 571F Received on Wed Jan 12 2000 - 11:12:05 CST

Original text of this message

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