PLS-00229: Attribute expression within SQL expression



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

Post New Answer

More Oracle Errors Interview Questions

RMAN-06556: datafile string must be restored from backup older than scn string

1 Answers  


ORA-14030: non-existent partitioning column in CREATE TABLE statement

1 Answers  


ORA-01866: the datetime class is invalid

3 Answers  


ORA-30945: Could not create mapping table 'string'

1 Answers  


TNS-00502: Invalid argument

1 Answers  






DRG-11833: Request-URI Too Big

1 Answers  


ORA-01945: DEFAULT ROLE[S] already specified

1 Answers  


ORA-01594: attempt to wrap into rollback segment (string) extent (string) which is being freed

1 Answers  


ORA-19810: Cannot create temporary controlfile file string in DB_RECOVERY_FILE_DEST

1 Answers  


RMAN-06578: INCREMENTAL LEVEL > 0 must be specified with FOR RECOVER OF

1 Answers  


LFI-00108: Open expect the file [string][string] to exist.

1 Answers  


ORA-19588: %s recid string stamp string is no longer valid

1 Answers  


Categories