Home » Developer & Programmer » Forms » Table Name (URGENT PLEASE PLEASE PLEASE)
Table Name (URGENT PLEASE PLEASE PLEASE) [message #78517] Wed, 27 February 2002 21:46 Go to next message
Imran
Messages: 56
Registered: November 2001
Member
Is any way that we can use a variable with FROM clause in a SELECT statement in FORMS like if we write in SQL

select * from &table_name;

Then it ask for the table name and we change that value each time it is executed. Similarly we can use in REPORTS a lexical parameter to handle that situation.
But in FORMS when we write this statement
select count(*) into variable_name
FROM :TEXT_ITEM;
Then generates errors in compilation time. Please help me because it causes me much trouble.

Report message to a moderator

Re: Table Name (URGENT PLEASE PLEASE PLEASE) [message #78522 is a reply to message #78517] Thu, 28 February 2002 00:41 Go to previous message
pratap kumar tripathy
Messages: 660
Registered: January 2002
Senior Member
use dynamic pl/sql

Report message to a moderator

Previous Topic: Form 6 format number
Next Topic: Calling Reports from Database
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sun Apr 20 06:11:05 CDT 2025
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.