-
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 ?
-
Does the procedure and table exist in both schema?
-
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
-
Forum Rules
|
|