Skip to Main Content
Forums

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!

How to create a stored procedure in a dynamic schema

user13065317May 1 2010 — edited May 1 2010
Hi,

I want to create a stored procedure in a dynamic shcema (schema name will be known at run time). Can any one guide me on this.
I tried using define var1=schema1; and then in create or replace procedure &var1.porcName( ) but it is not working

Thanks
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on May 29 2010
Added on May 1 2010
#database, #pl-sql, #plsql
2 comments
988 views