Pro*C on HP -- OPEN CURSOR fails !!!

From: pi_bimal <member30556_at_dbforums.com>
Date: Sat, 31 May 2003 13:20:49 +0000
Message-ID: <2943544.1054387249@dbforums.com>

We are working on a Pro*C based application, on UNIX. The application is supported on HP, AIX and SUN platforms.

Currently, for a particular dataset, the application fails on the HP system(core-dump) on executing an OPEN statement for a CURSOR.

The same OPEN CURSOR statement works fine, when the application is executed on a SUN system, against the same Database.

The CURSOR declaration statement is a simple select statement ... "SELECT a, b from SYS_SETUP where res_id = :rsrc"

Does anyone have any idea why the same application should behave differently on HP & SUN ?

On HP we are using Oracle 9.0.1.3 for Pro*C. On SUN, we use Oracle 9.2.0.1 for Pro*C.

The database server is on Oracle 9.2.0.1

Any ideas ???

--
Posted via http://dbforums.com

Received on Sat May 31 2003 - 08:20:49 CDT