Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...


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

DRG-11853: No Host Name Found

1 Answers  


ORA-25330: PL/SQL associative arrays may not be used with AQ array operations

1 Answers  


TNS-01028: Listener Log File string

1 Answers  


ORA-14509: specified VALIDATE INTO table form incorrect

1 Answers  


ORA-00220: controlfile not mounted by first instance, check alert log for more info

1 Answers  






ORA-24460: Native Net Internal Error

1 Answers  


QSM-00758: the specified parameter string is not valid for workload string

1 Answers  


ORA-08441: closed parenthesis missing in picture mask

1 Answers  


ORA-31433: subscriber view does not exist

1 Answers  


ORA-31500: change source string is not a ManualLog change source

1 Answers  


ORA-25153: Temporary Tablespace is Empty

1 Answers  


TNS-01417: "string" established:string refused:string state:string

1 Answers  






Categories