variables in sql-statements
From: Simon Schrammel <ssh_at_tetrag.ch>
Date: Wed, 13 Jun 2001 08:06:12 GMT
Message-ID: <U9FV6.100$io1.504251_at_news>
Date: Wed, 13 Jun 2001 08:06:12 GMT
Message-ID: <U9FV6.100$io1.504251_at_news>
Hello
I am creating a script which uses variables. I store the table-names in
these variables and I need to uses these variables in sql-statements. How
does this work in orcacle?
example:
declare
begin
select * from tab_name where col_name='ROM34';
end;
ERRORS:
tab_name varchar2(20);
col_name varchar2(20);
tab_name:='labor';
col_name:='name';
ORA-06550: line 7, column 15:
PLS-00356: 'TAB_NAME' must name a table to which the user has access
ORA-06550: line 7, column 1:
PL/SQL: SQL Statement ignored
Thank you for your help.
Simon Received on Wed Jun 13 2001 - 10:06:12 CEST