Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.tools -> variables in sql-statements

variables in sql-statements

From: Simon Schrammel <ssh_at_tetrag.ch>
Date: Wed, 13 Jun 2001 08:08:41 GMT
Message-ID: <dcFV6.101$io1.504326@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
tab_name varchar2(20);
col_name varchar2(20);

begin
tab_name:='labor';
col_name:='name';

select * from tab_name where col_name='ROM34';

end;

ERRORS:

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 - 03:08:41 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US