#1
  1. No Profile Picture
    Junior Member
    Devshed Newbie (0 - 499 posts)

    Join Date
    Jun 2002
    Posts
    2
    Rep Power
    0

    table names as variables


    I need to pass a table name as a parameter to a stored procedure. Does anyone know how to do this?
  2. #2
  3. Modding: Oracle MsSQL Firebird
    Devshed Supreme Being (6500+ posts)

    Join Date
    Jun 2001
    Location
    Outside US
    Posts
    8,527
    Rep Power
    539
  4. #3
  5. No Profile Picture
    Contributing User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Jan 2002
    Posts
    409
    Rep Power
    13

    Question


    teknocrat,

    Are you talking about using PL/pgSQL, or PHP?
  6. #4
  7. No Profile Picture
    Junior Member
    Devshed Newbie (0 - 499 posts)

    Join Date
    Jun 2002
    Posts
    2
    Rep Power
    0
    I don't mind if its in pl/pgsql or perlsql. However, i think have something that works. its messy - there are procedures within procedure but it seems to work.

IMN logo majestic logo spyfu logo threadwatch logo seochat tools logo