Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: calling stored procedure from Micro Focus COBOL

Re: calling stored procedure from Micro Focus COBOL

From: <GEBROSKY.MA_at_MELLON.COM>
Date: 1998/01/22
Message-ID: <885481066.323813384@dejanews.com>#1/1

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
Received on Thu Jan 22 1998 - 00:00:00 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US