Pro*COBOL + PL/SQL: ORACLE 7.2.3 hangs/loops

From: <FORMULA_FO_at_yahoo.com>
Date: Sat, 08 May 1999 16:41:39 GMT
Message-ID: <7h1pg2$n2m$1@nnrp1.deja.com>

I have a PRO*COBOL program that calls a PL/SQL procedure (30 parameters). This procedure calls another procedure (38 parameters) within the same package. When ORACLE tries to perform a RETURN from the inner function, the program's ORACLE process gets into an uncontrolled never-ending loop and uses a lot of CPU. Nothing is logged to the SQL trace file while ORACLE is looping.

The problem happens when the program accesses an ORACLE 7.2.3.0.0 database on an IBM AIX 4.1.4 server. When exactly the same program (same program file) accesses an ORACLE 7.3.4 database on an IBM 4.3 machine, the program works fine.
Also: The problem only happens when the procedure is called from COBOL. If called from sql*plus, it works fine on both database versions.

Thanks a lot in advance for any hints.
Erik

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Sat May 08 1999 - 11:41:39 CDT