SQLCODE=-52 : Cursor C10 already declared
Hi,
My routine contains embedded SQL including this:
&sql(DECLARE C1 CURSOR FOR
The error "SQLCODE=-52 : Cursor C10 already declared" comes up on compilation in Studio. Does anyone know a way around it please?
Bob
Comments
If you have multiple cursors anywhere in the class with the same name, that will come up. If it says C10, then you must have two different places where you're doing a "DECLARE C10 CURSOR FOR . . ." and you'll have to rename one of those cursors.
Thanks David. I was declaring cursor C1 in two locations in the routine (no C10 though). I have now renamed one of them to C2 and Studio has compiled it without error.
Great! Just a reminder, make sure you've made that change in all of your other statements for that cursor (open, fetch, close, etc.)
Yes I did a search and replace. Cheers!