SQLCODE=-52 : Cursor C10 already declared

Question

Question

Robert Steed · Sep 22, 2022

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

Product version: Caché 2018.1

$ZV: Cache for Windows (x86-64) 2018.1.7 (Build 721U) Fri Mar 18 2022 22:07:35 EDT

Discussion (4)1

Log in or sign up to continue

David Hockenbroch · Sep 22, 2022

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.

1 0

score 0 · Answer 1 · 2022-09-22T08:46:09-04:00

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.

score 0 · Answer 2 · 2022-09-22T08:48:05-04:00

Great! Just a reminder, make sure you've made that change in all of your other statements for that cursor (open, fetch, close, etc.)

score 0 · Answer 3 · 2022-09-22T08:49:17-04:00

Robert Steed · Sep 22, 2022

Yes I did a search and replace. Cheers!

0 0