Home » Developer & Programmer » Forms » Dynamic Table name problem
Dynamic Table name problem [message #78502] Tue, 26 February 2002 23:30 Go to next message
Messages: 56
Registered: November 2001
can we use a dynamic table name in the trigger of FORM
for example

in any trigger code :

select count(*) into :display_item5 from variable_name [[ dynamic table name ]];

can we do this ?
Re: Dynamic Table name problem [message #78509 is a reply to message #78502] Wed, 27 February 2002 02:27 Go to previous message
pratap kumar tripathy
Messages: 660
Registered: January 2002
Senior Member
u have to use dynamic sql. see dbms_sql package or execute immediate for details
Previous Topic: Unable To Insert Record
Next Topic: Receiving e-mail
Goto Forum:

Current Time: Mon May 20 07:04:23 CDT 2024