Results 1 to 3 of 3
  1. #1
    Join Date
    Apr 2004
    Posts
    15

    Unanswered: Passing TableName and ColumnName as prameters, to Procedure

    Is it possible to pass Table Names and Column Names as Parameters
    to Procedures? If so, how? (what would be the syntaxt)

    CREATE PROCEDURE MyProc(
    p_var1 <table_name_parm>.<column_name_parm>
    BEGIN
    ......... );
    END MyProc;
    ___________________

    Thanks

  2. #2
    Join Date
    Apr 2003
    Location
    Greenville, SC (USA)
    Posts
    1,155
    Yes you can pass them in as parameters. You then use dynamic SQL in the procedure to reference them ... There was a post on this forum
    either last week or the week before on this topic ...

    HTH
    Gregg

  3. #3
    Join Date
    Apr 2004
    Posts
    15
    Thanks Gregg,

    I haven't come across that posting, but few minutes after I posted my
    question I found something related at following link:

    http://www.algonet.se/~sommar/dynamic_sql.html

Posting Permissions

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