variable in implicit cursor problem [message #37200] |
Thu, 24 January 2002 02:16 |
John D. Elliott
Messages: 3 Registered: October 2001
|
Junior Member |
|
|
All,
Here is the simple version of the code.
declare
v_schema varchar2(30);
begin
v_schema := 'scott.emp';
select * from v_schema;
end;
/
I get the pls-00201 error that v_schema is not declared. I even try and substitute in place of the variable scott.emp and it says scott is not declared. I know this must be something simple, but I have tried everything I can think of. I have tried quoting, separating the schema and table name into different variables, etc.
Any suggestions would be very welcomed.
Thanks,
John
|
|
|
|