select command with a variable in PL/SQL?

From: Klaus Hartjes <hartjes_at_uni-muenster.de>
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

Original text of this message