table level trigger doesn't like 'execute_query'

From: M Hamilton <mhamilton_at_usgs.gov>
Date: 4 Feb 2004 15:44:00 -0800
Message-ID: <7ce65461.0402041544.72c47221_at_posting.google.com>

[Quoted] I am using Oracle Designer 6i Forms. I have created a table level trigger. The trigger calls a function that derives a value for a column. It doesn't display it on the form once it is derived. I know that if this were a WHEN_BUTTON_PRESSED form level trigger I could use 'EXECUTE_QUERY' and 'SYNCHRONIZE' to get the form to requery and display the new values in the record. But, when I put this into the table trigger, Designer says that:

CDS-11307 Warning: (compilation error in TRIGGER 'INSERT_NEW_ITEM' at 18/7): PLS-00201: identifier 'EXECUTE_QUERY' must be declared

CDS-11307 Warning: (compilation error in TRIGGER 'INSERT_NEW_ITEM' at 18/7): PL/SQL: Statement ignored

Same for the 'SYNCHRONIZE'. Is there a piece of code that I need to add or some characters before these, for them to be legit?

Thanks much,
Maggie Received on Thu Feb 05 2004 - 00:44:00 CET