HELP needed in using restricted package procedures of SQLFORMS

I have ORACLE 6.0 UNIX version installed on Sun SPARC station.

Problem : Invoking the restricted package procedure 'LIST_VALUES' in the trigger KEY-LISTVAL causes no problem. But, in order to put up the pop-up list of values automatically on entering the field, I tried to invoke 'LIST_VALUES' in the PRE-FIELD trigger. This caused the error FRM-40737(Illegal restricted procedure LIST_VALUES in PRE-FIELD trigger) to appear, on entering the field.

Can anyone out there help me with this problem ?

One more problem :

During form design using sqlforms, in the ON-VALIDATE-FIELD trigger, I have a PL/SQL BEGIN-END block. Within the block if I give any 'GRANT' or 'CONNECT' statement, I get PL/SQL compilation errors on pressing 'Accept' key. The error is 'Unsupported keyword 'GRANT' comes. While a .pc file having GRANT or CONNECT statements can be peacefully pcc-compiled, I am not able to give them as PL/SQL text from within the field's SQL text during form design. Any help please ?

Thanks a lot in advance.

My email : SRIDHAR_B1_at_blrv1.verifone.com Received on Tue Jun 23 1992 - 11:48:02 CEST