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-29252: collection does not contain elements at index locations in call to dbms_sql.bind_array
ORA-09265: spwat: error temporarily suspending process
NZE-29110: Invalid PKCS #12 bag type
ORA-02283: cannot alter starting sequence number
ORA-32152: Cannot perform operation on a null number
PCC-01013: Invalid use of PIC N array variable "string" at line number in file string
RMAN-06550: clone database not mounted and db_name not set in init.ora
ORA-31642: the following SQL statement fails: string
QSM-02036: in-list present in mv
RMAN-06703: could not open file: "string" (reason=string)
ORA-09719: osncui: invalid handle.
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.