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-31211: DBMS_LDAP: PL/SQL - Invalid LDAP entry dn.
QSM-02130: expression not supported for fast refresh
ORA-02352: file truncated error
ORA-13217: invalid parameters supplied in ALTER INDEX statement
ORA-09938: Save of signal handlers failed.
ORA-02031: no ROWID for fixed tables or for external-organized tables
ORA-24348: Update or Delete without Where
ORA-01039: insufficient privileges on underlying objects of the view
ORA-02163: invalid value for FREELIST GROUPS
TNS-00108: TNS_ADMIN not defined
ORA-32163: Method called on Invalid Environment type
ORA-16567: Data Guard broker internal parser error at "string"