PLS-00229: Attribute expression within SQL expression
Answer / guest
Cause: An attribute expression, such as SQL%NOTFOUND, was
used in a SQL statement, but attribute expressions are
allowed only in procedural statements.
Action: To workaround this limitation, assign the value of
the attribute expression to a variable, then use the
variable in the SQL statement. For example, replace the
statement INSERT INTO audits VALUES (c1%ROWCOUNT, ...); with
the following statements: row_count := c1%ROWCOUNT; INSERT
INTO audits VALUES (row_count, ...);
Please add more information about this Error
Is This Answer Correct ? | 1 Yes | 0 No |
ORA-16096: ALTER DATABASE COMMIT TO SWITCHOVER TO PHYSICAL STANDBY
ORA-15197: suppressing string additional ASM messages
PCC-00135: Result Set Cursor usage is not standard SQL
CLSS-02207: error string getting status from vendor node monitor
TNS-00038: INTCTL: Poorly formed address or command string
ORA-26020: index string.string loaded successfully with string keys
ORA-25003: cannot change NEW values for this column type in trigger
ORA-26056: Can not unload from a view through the direct path.
ORA-15027: open files in diskgroup "string" preclude its dismount
ORA-07255: spini: cannot set up signal handler.
NNC-00403: program interface has not been initialised
ORA-32031: illegal reference of a query name in WITH clause