PLS-00371: at most one declaration for 'string' is permitted in the d

PLS-00371: at most one declaration for 'string' is permitted
in the declaration section

Question Posted / guest

4 Answers
29094 Views
I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

PLS-00371: at most one declaration for 'string' is permitted in the declaration section..

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

PLS-00371: at most one declaration for 'string' is permitted in the declaration section..

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

PLS-00371: at most one declaration for 'string' is permitted in the declaration section..

Answer / samuel

delete one of the declarative identifier in the declarative
block.it worked for me.

Is This Answer Correct ?

0 Yes

0 No

PLS-00371: at most one declaration for 'string' is permitted in the declaration section..

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

Post New Answer