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 |
SQL-02152: Invalid numeric variable for use in an array GET/SET statement
ORA-07842: sllfcl: SYS$CLOSE failure
ORA-38500: %s
DRG-10800: query failed: string string string
ORA-24385: Application context size or index is not valid
NZE-28772: invalid file ID
ORA-37133: (XSCCOMP08) Cannot write into an aggregated VARIABLE dimensioned by a COMPRESSED COMPOSITE. Use the CLEAR AGGREGATES command to reenable write access.
TNS-12640: Authentication adapter initialization failed
ORA-06030: NETDNT: connect failed, unrecognized node name
ORA-14186: number of sub-partitions of LOCAL index must equal that of the underlying table
ORA-26717: SCN limit reached
RMAN-06734: Do you really want to drop all backups and the database (enter YES or NO)?