Passing different tables as a input parameter
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
Could you give me an example of dynamic sql to passing my 5 tables as parameter?
Originally Posted by pando
Check this link
and as always the Oracle plsql packages reference.
Click Here to Expand Forum to Full Width