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-06193: connected to target database (not started)

3 Answers  


ORA-02261: such unique or primary key already exists in the table

1 Answers  


SQL*Loader-00803: %s field type not supported by External Table

1 Answers  


RMAN-08521: offline range recid=string stamp=string

1 Answers  


ORA-33922: (MAKEDCL35) You cannot define a surrogate of dimension workspace object because it is a time dimension.

1 Answers  


TNS-01404: Max Load: string

1 Answers  


ORA-32771: cannot add file to bigfile tablespace

2 Answers  


NNO-00054: invalid domain name "string"

1 Answers  


IMP-00070: Lob definitions in dump file are inconsistent with database.

0 Answers  


ORA-12593: TNS:no registered connection

1 Answers  


ORA-09878: sstascre/sstasat: shmat error, unable to attach tas write page

1 Answers  


ORA-19010: Cannot insert XML fragments

1 Answers  


Categories