Re: PL/SQL substitution question
Date: 5 May 92 08:36:01 GMT
Message-ID: <1992May5.083601.23797_at_lut.ac.uk>
In article <167DA7F63.M21444_at_mwvm.mitre.org> M21444_at_mwvm.mitre.org writes:
>
>
>I'm having a really annoying (and dumb) problem -- I'm writing a pro-C
>program and need to insert decimal values (float) into a table through a
>host variable. Sounds simple, but when I do this, my program bombs.
>
>The weird thing is, I bomb with a segmentation fault, NOT an ORACLE error.
>Just thought I'd see if anybody else has had a problem like this...I'm
>running on a SunOS 4.1 on a Sun 490, with ORACLE V6.0.
>
Well, my experience is close enough to be relevant, I suppose.
I had a 'segmentation fault' message several times when writing
user exits (to SQLForms & ReportWriter) in Fortran when real (=float)
values were involved. It seems that Oracle has difficulties
with numbers! I overcome this problem by putting the table values
concerned into character variables in the Oracle utility, & then reconverting
into real in the Fortran code.
This was using Oracle V6.0.3n on a HP9000/855 with HP-UX v7.
It seemed to be news to Oracle support!
Mavis
Received on Tue May 05 1992 - 10:36:01 CEST