How to avoid FRM-40654 in case of a data_based trigger ?

Posted on 2007-07-24
Medium Priority
Last Modified: 2008-01-09
Got FRM-40654 error message
when saving the oracle form APXINWKB in Oracle Payables (DB 10, Oracle application 11.5.10)

The pb seems to comes from a specific trigger based on the ap_invoices_all  table (works fine when the trigger is disabled).
Question by:quiberon
LVL 14

Accepted Solution

sathyagiri earned 2000 total points
ID: 19557272
Refer to this post for options and work arounds

Expert Comment

ID: 20228845
Forced accept.

EE Admin

Featured Post

Restore individual SQL databases with ease

Veeam Explorer for Microsoft SQL Server delivers an easy-to-use, wizard-driven interface for restoring your databases from a backup. No expert SQL background required. Web interface provides a complete view of all available SQL databases to simplify the recovery of lost database

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Cursors in Oracle: A cursor is used to process individual rows returned by database system for a query. In oracle every SQL statement executed by the oracle server has a private area. This area contains information about the SQL statement and the…
Configuring and using Oracle Database Gateway for ODBC Introduction First, a brief summary of what a Database Gateway is.  A Gateway is a set of driver agents and configurations that allow an Oracle database to communicate with other platforms…
Via a live example show how to connect to RMAN, make basic configuration settings changes and then take a backup of a demo database
This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.
Suggested Courses
Course of the Month16 days, 5 hours left to enroll

850 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question