Re: Accessing server output buffer

Ken Mizuta wrote:
>
> Muralidhar Krishnaprasad wrote:
> >
> > HI,
> >
> > I am developing an OCI script to access Oracle and was wondering
> > if there is any way to access the output of the server by
> > dbms_output.put_line thru OCI functions. Is it possible to bind
> > the output buffer to any buffer in C ?
> >
> > Thanks a lot,
> > Murali
> >
 

> If you look at the dbms_output package there is a function called
> get_line. You should simply use this to transfer the dbms_output buffer
> to a C-buffer. There is no direct OCI function to do what you are
> looking for.
>
> Ken Mizuta
>

With Oracle v7.3 PL/SQL has a new package called UTL_FILE. This will allow you to do very 'C' like i/o with calls like fopen, fclose, put, get_line, fflush, etc. I'm sure you could read into your 'C' program from the output of this package using standard 'C' calls.

brian.maclean_at_teldta.com

If we do not succeed, then we run the risk of failure.

• Vice President Dan Quayle, to the Phoenix Republican Forum, March 1990