PLS-00229: Attribute expression within SQL expression



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

Post New Answer

More Oracle Errors Interview Questions

ORA-16096: ALTER DATABASE COMMIT TO SWITCHOVER TO PHYSICAL STANDBY

1 Answers  


ORA-15197: suppressing string additional ASM messages

1 Answers  


PCC-00135: Result Set Cursor usage is not standard SQL

1 Answers  


CLSS-02207: error string getting status from vendor node monitor

1 Answers  


TNS-00038: INTCTL: Poorly formed address or command string

1 Answers  






ORA-26020: index string.string loaded successfully with string keys

1 Answers  


ORA-25003: cannot change NEW values for this column type in trigger

1 Answers  


ORA-26056: Can not unload from a view through the direct path.

1 Answers  


ORA-15027: open files in diskgroup "string" preclude its dismount

1 Answers  


ORA-07255: spini: cannot set up signal handler.

1 Answers  


NNC-00403: program interface has not been initialised

1 Answers  


ORA-32031: illegal reference of a query name in WITH clause

2 Answers  


Categories