Home » Developer & Programmer » Forms » How to use “Select into” clause in FORMS_DDL?
How to use “Select into” clause in FORMS_DDL? [message #81235] Fri, 24 January 2003 14:48 Go to next message
Swamy
Messages: 78
Registered: June 2002
Member
I need to populate row count into a Form field. Here the where clause is coming based on a variable. This is somewhat like as mentioned below.

Declare
L_where varchar2(1000) := DEP_ID = 12;

Begin
FORMS_DDL(SELECT COUNT(1) INTO :EMPBLOCK.COUNTALL FROM EMP WHERE || l_where);
End;

I tried this in a trigger, but not populating the COUNTALL field of EMPBLOCK block. Can any one tell me how to accomplish this task? Thanks in advance for your help.
Re: How to use “Select into” clause in FORMS_DDL? [message #81236 is a reply to message #81235] Fri, 24 January 2003 18:20 Go to previous messageGo to next message
magnetic
Messages: 324
Registered: January 2003
Senior Member
use into v_variabel in stead of a :block.item
Re: How to use “Select into” clause in FORMS_DDL? [message #81245 is a reply to message #81235] Sun, 26 January 2003 13:36 Go to previous message
Swamy
Messages: 78
Registered: June 2002
Member
into v_variable is not working and I am getting ORA-01403: no data found error. Any other solution!
Previous Topic: Popup windows
Next Topic: forms6i abnormal termination
Goto Forum:
  


Current Time: Fri Mar 29 10:52:18 CDT 2024