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-26050: Direct path load of domain index is not supported for this column type.
PCC-02403: Invalid indicator variable type for this host variable
NZE-28800: data source failed to open
ORA-09813: Unable to get directory status
QSM-01036: unmatched column, string, present in query after view merging
ORA-24160: name string already exists in the name value pair list
ORA-31160: max substitution group size string exceeded by "string" (string) for head element "string" (string)
RMAN-06205: Uncataloged string objects
ORA-02493: invalid file increment size in NEXT clause
PCC-02044: CMD-LINE: Illegal or out of range value for option:
ORA-29877: failed in the execution of the ODCIINDEXUPDATE routine
PCC-02102: Fatal error while doing C preprocessing