Getting -504 Cursor Name GTT-ARTS-CURSOR is not Declared

Robin Sulsona · Posted: Fri Mar 17, 2017 1:43 am

I have a COBOL program (RSJUNK) that is calling a Stored Procedure (SPJUNK). The Stored Procedure is building my GTT and when I am done I open a cursor that is defined "WITH RETURN TO CALLER" as part of the DECLARE.

When I return to RSJUNK, I look to see if it found data or not based on the content of my "output" parm of my stored procedure. When I have data I am doing the "ASSOCIATE LOCATORS (:L0C) WITH PROCEDURE SPJUNK " and the "ALLOCATE GTT CURSOR FOR RESULT SET :LOC".

When I then try to fetch this cursor, I am getting a -504 Cursor name is not declared. Could someone please shed some light on what I am missing?

Thanks for any help you can provide.

Robin Sulsona · Posted: Sat Mar 18, 2017 12:50 am

I have found my problem. Stored Procedures are new for me so I didn't know that I needed to do the Create Procedure with a RESULT SET 1. I copied my create from the other Stored Procedure and it was RESULT SET 0. I found another person in our dept. that had done this and he gave me 2 sample programs to look at. My code was good but I decided to look at the create procedure DDL and found that he had a value other than 0.

Now everything is working like I need it to for unit testing.

Hope that this may help someone else in the future.

Rohit Umarjikar · Posted: Mon Mar 20, 2017 8:11 pm

Yes, it will . Thanks