Re: variables in sql-statements

From: Thomas Jegen <thomas.jegen_at_siemens.ch>
Date: Wed, 13 Jun 2001 13:32:08 +0200
Message-ID: <3B274F38.EA5D6B23@siemens.ch>

It is not possible to direct replace database objects such as tables, columns etc with variables.

To be able to use dynamic SQL you have to use either the package dbms_sql or 'execute immediate'.

Thomas  

---

Siemens Switzerland Ltd, Softwarehaus, ES41 Thomas Jegen, Software Engineer
Albisriederstrasse 245, CH-8047 Zürich
Phone +41 (0)1 495 3438, Fax +41 (0)1 406 5340 mailto:thomas.jegen@siemens.ch, Internet: http://www.siemens.ch/ Received on Wed Jun 13 2001 - 06:32:08 CDT