Passing different tables as a input parameter
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5

Thread: Passing different tables as a input parameter

  1. #1
    Join Date
    Jul 2002
    Posts
    228

    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!

  2. #2
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    you need to use Dynamic Sql

  3. #3
    Join Date
    Jul 2002
    Posts
    228
    Quote 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.

  4. #4
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    show the code please

  5. #5
    Join Date
    Dec 2000
    Posts
    138
    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
  •  


Click Here to Expand Forum to Full Width