Oracle Cursors , Need Help Immediately !

 have a set of COBOL PROGRAMS which call SQL Functions.

1. COBOL PROGRAM 'A' Opens Cursor to access File-1
2. COBOL PROGRAM 'A' calls COBOL PROGRAM 'B'
3. COBOL PROGRAM 'B' Needs to call the same function that PROGRAM 'A' called to open a uniq cursor for File-1, but the DECLARE Cursor clause does not accept a FIELD, but is the actual name of the cursor.

Please tell me how to make these declarations of cursors unique from each other. If they have the same name the 2nd cursor replaces the 1st.

PLEASE SEND ANSWERS to cobyh_at_consygen.com

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Wed Oct 07 1998 - 08:38:29 CDT