-
Passing different tables as a input parameter
HI,
I've 5 tables TAB1, TAB2, TAB3, TAB4, TAB5
and I created 5 store procedures to generate 5 file.txt with utl_file utility.
Now I'd like to know if possible create just one stored procedure (or package) with just one cursor
that passing different tables as a input parameter.
Have you any idea?
Thanks in advance!
-
you need to use Dynamic Sql
-
Originally Posted by pando
you need to use Dynamic Sql
Could you give me an example of dynamic sql to passing my 5 tables as parameter?
Thanks.
-
-
Check this link
http://www.psoug.org/reference/dbms_sql.html
and as always the Oracle plsql packages reference.
-dharma
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|