PLS-00341: declaration of cursor 'string' is incomplete or
malformed
- 1 Answers
- 5620 Views
- I also Faced
- E-Mail Answers
Answer / guest
Cause: A cursor declaration is improper or an identifier
referenced in the cursor declaration was not properly
declared. A return type that does not refer to an existing
database table or a previously declared cursor or cursor
variable might have been specified. For example, the
following cursor declaration is illegal because c1 is not
yet fully defined: CURSOR c1 RETURN c1%ROWTYPE IS SELECT ...
-- illegal In this case, a return type does not have to be
specified because it is implicit.
Action: Check the spelling and declaration of the cursor
name and any identifiers referenced in the cursor
declaration. Also confirm that the declaration is placed
correctly in the block structure. If a return type was
specified, make sure that it refers to an existing database
table or a previously declared cursor or cursor variable.
Please add more information about this Error
| Is This Answer Correct ? | 1 Yes | 0 No |
LFI-00104: Read operation failed.
DRG-10101: no value for argument: string
[ERROR] [main 11:01:20] (JCLLoggerAdapter.java:error:454) Unsuccessful: alter table user.CEN_USER_MASTER add constraint FKF4EDEDC3D0BAAE75 foreign key (ROLE_ID) references user.CEN_ROLE_MASTER [ERROR] [main 11:01:20] (JCLLoggerAdapter.java:error:454) ORA-02275: such a referential constraint already exists in the table
ORA-00338: log string of thread string is more recent than controlfile
ORA-24386: statement/server handle is in use when being freed
TNS-00090: * Interchange - will ask the Interchange
ORA-27102: out of memory
ORA-01201: file string header failed to write correctly
PLS-00643: booleans, index tables, records and cursors not allowed in SQL statements
EXP-00045: Cannot export SYSTEM Tablespace for Point-in-time Recovery or Transportable Tablespace
ORA-14311: Expecting VALUES LESS THAN or AT clause
PLS-00127: Pragma string is not a supported pragma
Oracle Errors 
