select command with a variable in PL/SQL?
Date: 1996/11/13
Message-ID: <56copt$4k9a_at_asterix.uni-muenster.de>#1/1
Hello,
We run a Oracle-Server 7.0 with Forms 4.5 on a IBM-RS6000 with AIX 4.0.
In our database exists a table >>persons<< with a column >>name<<.
In Forms the following PL/SQL-Statement works fine:
SELECT name INTO dummy FROM persons WHERE .....
We now have the problem that we want to replace the tablename >>persons<<
with a variable:
SELECT name INTO dummy FROM &variable WHERE .....
In SQLPLUS this works but not in PL/SQL.
So, does anybody have a solution for this problem?
Greetings
Klaus Hartjes
--
Dr. Klaus Hartjes, Dipl. Phys. Westfaelische Wilhelms-Universitaet
Universitaetsrechenzentrum Einsteinstr. 60
hartjes_at_uni-muenster.de 48149 Muenster, Germany
Received on Wed Nov 13 1996 - 00:00:00 CET