Re: Proc*c help

[Quoted] "Volker Hetzer" <volker.hetzer_at_ieee.org> a écrit dans le message de news:c4h8cq$s2c$1_at_nntp.fujitsu-siemens.com...
>
> "G Dahler" <yellow-shark_at_spamex.com> schrieb im Newsbeitrag
news:1KFac.57703$1A6.1299582_at_news20.bellglobal.com...
> >
> > "Jay" <jayanes_at_hotmail.com> a écrit dans le message de
> > news:9d845314.0403311003.35d41c67_at_posting.google.com...
> > > All,
> > >
> > > I am trying to put a PL/SQL block ( with UTL_FILE file process )
> > > within a pro*c program.
> > >
> > > I was able to compile with cc ( gmake ), but getting a 'STOP ERROR'.
> > > The PL?SQL block itslef is workg fine under sqlplus.
> > >
> > > Any idea as whether it is possible to run PL/SQL (with UTL_FILE) to
> > > run embedded in pro*c?
> > >
> > > Thanks
> > >
> >
> > Why would you use UTL_FILE in a PRO*C program ? Use open() read() and
> > write() !
> >
> > If you are already at the PRO*C level, why not simply use the native C
> > library: lot more options than UTL_FILE, lot more flexible, lot more
> > powerful.
> Maybe he wants to work with files on the server machine?
>
> Lots of Greetings!
> Volker
>

In this case, all he have to do is either use external procedure calls (C API, available in 8i+) or compile his pro*c program on the server side. Received on Thu Apr 01 2004 - 16:24:09 CEST