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

From: Harald Maier <maierh_at_myself.com>
Date: Tue, 03 Jun 2003 11:13:57 +0200
Message-ID: <m3d6hvcylm.fsf@ate.maierh>

pi_bimal <member30556_at_dbforums.com> writes:

> 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.

Are you shure that you precompiled your source on both targets. Harald Received on Tue Jun 03 2003 - 04:13:57 CDT