Operating System - HP-UX
1752284 Members
4393 Online
108786 Solutions
New Discussion юеВ

Re: Cobol error at runtime: ORA-01006:bind variable doesn't exist

 
Frank Morales
New Member

Cobol error at runtime: ORA-01006:bind variable doesn't exist

I'm running Microfocus Cobol for Unix 4.1 revision 030.
When executing a COBOL program I got the Oracle error: bind variable doesn't exist. When I traced the error I found it was happening when opening a cursor. Actually, the cursor got opened, fetched, and closed 2 times, but on the third time it aborts in the OPEN CURSOR statement.
We use HPUX 11
Have you heard of any similar error or some way to fix it?
3 REPLIES 3
Keith Hughes_2
Advisor

Re: Cobol error at runtime: ORA-01006:bind variable doesn't exist

Frank,

I am sorry that you will have to contact Oracle re this problem.

I have checked up and found no record of this on HP'S knowledge database.

Keith
Alex Glennie
Honored Contributor

Re: Cobol error at runtime: ORA-01006:bind variable doesn't exist

ORA-01006: bind variable does not exist

Cause: A program issued a BIND call for a variable not listed in the associated SQL statement. Only those variables prefixed by either a colon (:)
or ampersand (&) in the SQL statement may be referenced in a BIND call, OBIND or OBINDN. This error may also be caused by a mismatch
between a Precompiler program and the related library, SQLLIB.

Action: Modify the BIND call to reference one of the substitute variables specified in the associated SQL statement.

FYI : http://www.daimi.au.dk/~oracle/doc/server.805/a58312/newch221.htm
Frank Morales
New Member

Re: Cobol error at runtime: ORA-01006:bind variable doesn't exist

Thank for your reply. I'm also working with Oracle on this issue.