Results 1 to 2 of 2
  1. #1
    Join Date
    Jul 2009
    Posts
    11

    Unanswered: dynamic table parameter

    declare
    CURSOR CURCOL IS
    SELECT COLUMN_NAME
    FROM USER_TAB_COLUMNS
    WHERE TABLE_NAME = XTABLE
    AND COLUMN_NAME <> 'WO_NUMBER'
    ORDER BY COLUMN_ID DESC;
    begin
    -- do statement here...
    end;

    my question is that is it possible in the cursor statement to pass a dynamic table parameter?

    I mean your table_name qualifier would be a variable which is dynamic..

    Thanks in advance...

  2. #2
    Join Date
    Jul 2009
    Posts
    11
    The answer for my question is in my head...

    Problem solved...

    To Mods: Pleae close this thread.. Thanks..

    By the way, the answer to my questions is that dont include schema name in the qualifier and convert it to upper case..

    Thanks...

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •