raj416


hi ,

i got this error ... i have tried various scenarios.. nothing works for me... can any one gimme the proper guidance...

The variable name '@CCSID' has already been declared. Variable names must be unique within a query batch or stored procedure.

thanx in advance

raj




Re: Variable names must be unique within a query batch or stored procedure.

Kent Waldrop My07


You probably need to show us your code. This looks like you have two DECLARE @CCSID statements in the batch, but it will help if you can show your code.




Re: Variable names must be unique within a query batch or stored procedure.

raj416

hey kent ,

thax for ur reply ...you are right

i have fixed the issue ...while validating the parameter i have declared second time(while debugging i came to know it was declared twice..little bit tricky (more than 2000 lines)...but i have managed it...

i think this error comes often assigning parameter inside loop

cheers,

raj






Re: Variable names must be unique within a query batch or stored procedure.

nayle

hi,

i have teh same problem like you.i cant insert more then 2 records.when i want to insert more then 2 records .i get a error the variable must be unique...........Can you help me how i can manage the error.

Thanks!!!