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-30737: cannot create subtable of a type which is not a subtype of the type of the supertable
PCC-00104: FOR clause is an Oracle extension
ORA-25953: join index cannot be a functional index
PLS-00509: Implementation Restriction : Pass a returned record to a temporary identifier before selecting a field
ORA-29852: keyword IS is missing
QSM-02137: agg(expr) requires correspondng STDDEV(expr) function
ORA-14044: only one partition may be moved
ORA-12675: External user name not available yet
ORA-29283: invalid file operation
ORA-01606: gc_files_to_locks not identical to that of another mounted instance
ORA-31018: Error deleting XML document
IMG-00502: invalid scale value