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

ORA-29252: collection does not contain elements at index locations in call to dbms_sql.bind_array

1 Answers  


ORA-09265: spwat: error temporarily suspending process

1 Answers  


NZE-29110: Invalid PKCS #12 bag type

1 Answers  


ORA-02283: cannot alter starting sequence number

1 Answers  


ORA-32152: Cannot perform operation on a null number

1 Answers  






PCC-01013: Invalid use of PIC N array variable "string" at line number in file string

1 Answers  


RMAN-06550: clone database not mounted and db_name not set in init.ora

1 Answers  


ORA-31642: the following SQL statement fails: string

1 Answers  


QSM-02036: in-list present in mv

1 Answers  


RMAN-06703: could not open file: "string" (reason=string)

1 Answers  


ORA-09719: osncui: invalid handle.

1 Answers  


In my project I am using star schema and only diimension tables are loaded and not fact tables any one can help me why it is happening? Plase guide me.

0 Answers  


Categories