PLS-00371: at most one declaration for 'string' is permitted
in the declaration section
Answers were Sorted based on User's Feedback
Answer / dinesh
You have declared the variable name or type twice. check
the variable name or type which was duplicated.
Is This Answer Correct ? | 5 Yes | 1 No |
Answer / john doe
I am acctually a very newby beginner but the error occured
because i used the Tablename instead of the cursor.
switched
anyVar myTable.theField%TYPE;
to
anyVar myCursor.theField%TYPE;
And the error dissapeared.
Regards
Jan
Is This Answer Correct ? | 2 Yes | 2 No |
Answer / samuel
delete one of the declarative identifier in the declarative
block.it worked for me.
Is This Answer Correct ? | 0 Yes | 0 No |
Answer / guest
Cause: A reference to an identifier is ambiguous because
there are conflicting declarations for it in the declarative
part of a block, procedure, or function. At most one
declaration of the identifier is permitted in a declarative
part.
Action: Check the spelling of the identifier. If necessary,
remove all but one declaration of the identifier.
Please add more information about this Error
Is This Answer Correct ? | 2 Yes | 3 No |
PLS-00615: type mismatch found at 'string' between CASE operand and WHEN operands
ORA-04094: table string.string is constraining, trigger may not modify it
ORA-28008: invalid old password
ORA-06260: NETNTT: cannot write to remote process
O2I-00120: Error reported by subsystem:
NZE-28817: PL/SQL function returned an error.
ORA-06979: X.25 Driver: server cannot start oracle
PCC-01003: Invalid continuation at line number in file string
ORA-24422: error occurred while trying to destroy the Session Pool
SQL-02106: Inconsistent cursor cache. Invalid Oracle cursor number
ORA-02478: merge into base segment would overflow MAXEXTENTS limit
ORA-12001: cannot create log: table 'string' already has a trigger