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 |
PCC-01515: FIPS warning: Undeclared host variable "string" at line number in file string
ORA-01263: Name given for file destination directory is invalid
PLS-00223: paramaterless procedure 'string' used as function
O2F-00340: Name was null
ORA-38469: invalid privilege for an expression set: string
ORA-31453: invalid value string for parameter, expecting: Y, N, or NULL
ORA-12005: may not schedule automatic refresh for times in the past
ORA-01763: update or delete involves outer joined table
SQL*Loader-00929: Error parsing insert statement for table string.
ORA-19591: backup aborted because job time exceeded duration time
ORA-01189: file is from a different RESETLOGS than previous files
IMP-00044: unable to allocate enough memory for statement