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-15169: destination 'string' is a subdirectory of 'string'
SQL*Loader-00103: Invalid log file name on command line
LPX-00121: undefined notation "~S"
ORA-16642: db_unique_name mismatch
ORA-00476: RECO process terminated with error
ORA-02796: Done request is not in correct state
RMAN-06489: no configuration found to allocate clone channel number for device type string
ORA-30132: invalid key index supplied
ORA-07419: sfareq: Database writer got error in timing function.
ORA-22601: pickler TDS context [string] is not initialized
ORA-31221: DBMS_LDAP: PL/SQL - Invalid LDAP SSL wallet passwd.
ORA-02483: Syntax error in process specification (string)