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 ?