| How to use “Select into” clause in FORMS_DDL? [message #81235] |
Fri, 24 January 2003 14:48  |
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.
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
