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-22339: cannot alter to not final since its attribute column is substitutable

1 Answers  


NNL-00804: Queries received, type META-DATA: number

1 Answers  


RMAN-06025: no backup of log thread number seq number lowscn string found to restore

1 Answers  


ORA-01255: cannot shutdown - file string in recovery manager backup

1 Answers  


ORA-07272: spwat: invalid semaphore set id.

1 Answers  






ORA-00276: CHANGE keyword specified but no change number given

1 Answers  


ORA-01638: parameter string does not allow ORACLE version string to mount cluster database

1 Answers  


PCC-02106: Userid only used when SQLCHECK = FULL, userid ignored.

1 Answers  


ORA-24127: TABLESPACE parameter specified with an ACTION other than CREATE_ACTION

1 Answers  


IMG-00720: image processing internal error

1 Answers  


ORA-02853: Invalid server list latch time out value

1 Answers  


ORA-33022: (XSAGDNGL10) The measure dimension workspace object must be a TEXT or ID base dimension that does not dimension AGGMAP workspace object, but is in the same analytic workspace.

1 Answers  


Categories