Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: calling stored procedure from Micro Focus COBOL
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 UsenetReceived on Thu Jan 22 1998 - 00:00:00 CST