Home » Developer & Programmer » Forms » Dynamic Table name problem
Dynamic Table name problem [message #78502] Tue, 26 February 2002 23:30 Go to next message
Imran
Messages: 56
Registered: November 2001
Member
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 ?

Report message to a moderator

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

Report message to a moderator

Previous Topic: Unable To Insert Record
Next Topic: Receiving e-mail
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Wed Sep 03 22:56:51 CDT 2025
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.