Re: calling stored procedure from Micro Focus COBOL

>Subject: Re: calling stored procedure from Micro Focus COBOL
>From: GEBROSKY.MA_at_MELLON.COM
>Date: 1/22/98 3:01PM GMT
>Message-id: <885481066.323813384_at_dejanews.com>
>
>I do have indicator values in the call from COBOL. What is strange is as
>long as the SP returns a non-null value it works. As soon as a null
>return value is introduced it hangs.
>
>In article <01bd26ba$0f7c0340$7c1179c3_at_pc-guus>,
> "Guus van de Sande" <dyntas_at_wxs.nl> wrote:
>>
>> I'm not sure how this works with Oracle Server, but with Oracle Rdb you
>> should use INDICATOR-records in COBOL/Embedded SQL to detect NULL-values.
>>
>> regards,
>> Guus van de Sande
>>
>> gebrosky.ma_at_mellon.com schreef in artikel
>> <885418896.203096068_at_dejanews.com>...
>> > Has anyone succesfully called a stored procedure from a COBOL program
>> > where the stored procedure may return a null value in an out parameter?
>> > When I try to return a null value the SP hangs on the server running up
>> > CPU time. As long as I return values everything works fine.
>> >
>> > Thanks
>> >
>> > -------------------==== Posted via Deja News ====-----------------------
>> > http://www.dejanews.com/ Search, Read, Post to Usenet
>> >
>
>-------------------==== Posted via Deja News ====-----------------------
> http://www.dejanews.com/ Search, Read, Post to Usenet
>
>
>
>
>
>
>

We experienced a similar problem where I work a couple of years ago. ORACLE support were no help whatsoever, so the only thing we could do was to change the sp so that it didn't return null.
Great eh ?

Rob Received on Sat Jan 24 1998 - 00:00:00 CST