Re: table level trigger doesn't like 'execute_query'

"M Hamilton" <mhamilton_at_usgs.gov> wrote in message news:7ce65461.0402041544.72c47221_at_posting.google.com...
> 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?

You're trying to add Forms built-ins to a database trigger, which is not possible.
Forms and the database are two separate environments.

Theo Received on Fri Feb 06 2004 - 21:00:59 CET