Home » Developer & Programmer » Forms » Is it possible to get the table name from the user. (6i)
Is it possible to get the table name from the user. [message #678724] Sun, 05 January 2020 02:48 Go to previous message
amjad_alahdal
Messages: 102
Registered: October 2013
Location: Saudi Arabia
Senior Member
I am writing a Procedure. In the procedure the table name should be given from the user.
Is it possible to assign the table name this way?
EX.
PROCEDURE GE IS 
COUNTER NUMBER ; 
TABLE_N VARCHAR2(15);
BEGIN 
TABLE_N = :A.ITEM_NAME; 
SELECT COUNT(*) INTO COUNTER 
FROM 
TABLE_N ; 
--------------------------------------------------
Can I make the user assign the table name from his end ?
 
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Previous Topic: cannot understand what is the problem
Next Topic: Sum of Amount with Items of Two different Groups
Goto Forum:
  


Current Time: Fri Aug 07 05:08:12 CDT 2020