Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Executing create or replace procedure statement from plsql script

user588487Oct 9 2012 — edited Oct 10 2012
Hi ,

I want to execute create or replace procedure from pl/sql block without using execute immediate or dbms_sql, please let me know if feasible.

Eg:

declare
begin

create or replace procedure .....
.........

if v_temp = 4 then
.....

end if;

end;

Thanks for help.



Regards,
RK
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Nov 7 2012
Added on Oct 9 2012
9 comments
428 views