Home » SQL & PL/SQL » SQL & PL/SQL » create a procedure dynamic in another procedure???
create a procedure dynamic in another procedure??? [message #22108] Tue, 24 September 2002 03:54 Go to next message
Daniel
Messages: 47
Registered: February 2000
Member
Here is my Code-Block:

1 create or replace procedure dynamic_test is
2 string varchar2(200);
3 begin
4 string := 'create or replace procedure forum.dyn is
5 begin
6 end;';
7 execute immediate string;
8 end;

....and i've got these messages:
ORA-24344: succes with compilation error
ORA-06512: at "FORUM.DYNAMIC_TEST", line 7
ORA-06512: at line 1

intern sql*plus 2087, too risky to go on
(not very good *g* translation from the german version)

Thx a lot for your help
Daniel
Re: create a procedure dynamic in another procedure??? [message #22111 is a reply to message #22108] Tue, 24 September 2002 05:10 Go to previous message
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
make sure u grant the CREATE PROCEDURE PRIVILEGE explicitly as shown.
SQL> connect sys
Enter password: ***
Connected.
SQL> grant create procedure to mag;

Grant succeeded.

SQL> connect mag
Enter password: ***
Connected.
SQL> set serveroutput on
SQL>  create or replace procedure dynamic_test is
  2   string varchar2(200);
  3   begin
  4   string := 'create or replace procedure dyn is begin dbms_output.put_line(''asdf''); end;';
  5   execute immediate string;
  6   end;
  7  /

Procedure created.

SQL> exec dynamic_test;

PL/SQL procedure successfully completed.

SQL> exec dyn
asdf

PL/SQL procedure successfully completed.

SQL> 

Previous Topic: How many
Next Topic: Cursor loop performance
Goto Forum:
  


Current Time: Wed May 08 00:50:06 CDT 2024