Results 1 to 3 of 3

Thread: Invoker rights Procedure-Variable not in select list

  1. #1
    Join Date
    Sep 2005
    Posts
    2

    Invoker rights Procedure-Variable not in select list

    I have a invoker rights procedure compiled in schema A
    The schema has a table 'X' with n columns.
    the procedure uses a cursor c1 as
    select * from X
    for cur1 in c1 loop
    ....
    end loop

    when the procedure executes in schema B which has table X
    with (n-1) columns ,I get the error :
    variable not in select list

    How can I resolve this error ?

  2. #2
    Join Date
    Nov 2002
    Location
    New Jersey, USA
    Posts
    3,932
    Does the procedure and table exist in both schema?

  3. #3
    Join Date
    Sep 2005
    Posts
    2
    synonym for procedure in schema A exists in the 2nd schema B from which proc is run.

    The schema A has the actual table.

    schema B has a view with same name as table in schema A
    and view defintion is :
    select all columns (except last column) from table in schema A.

Posting Permissions

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