Proc*c help

[Jay]

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

J

[G Dahler]

"Jay" <jayanes@hotmail.com> a écrit dans le message de
news:9d845314.0403311003.35d41c67@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.

[Volker Hetzer]

"G Dahler" <yellow-shark@spamex.com> schrieb im Newsbeitrag news:1KFac.57703$1A6.1299582@news20.bellglobal.com... "Jay" <jayanes@hotmail.com> a écrit dans le message de news:9d845314.0403311003.35d41c67@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

[G Dahler]

"Volker Hetzer" <volker.hetzer@ieee.org> a écrit dans le message de
news:c4h8cq$s2c$1@nntp.fujitsu-siemens.com... "G Dahler" <yellow-shark@spamex.com> schrieb im Newsbeitrag
news:1KFac.57703$1A6.1299582@news20.bellglobal.com... "Jay" <jayanes@hotmail.com> a écrit dans le message de news:9d845314.0403311003.35d41c67@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.

[Volker Hetzer]

"G Dahler" <yellow-shark@spamex.com> schrieb im Newsbeitrag news:mCVac.17440$j57.927194@news20.bellglobal.com... "Volker Hetzer" <volker.hetzer@ieee.org> a écrit dans le message de news:c4h8cq$s2c$1@nntp.fujitsu-siemens.com... Maybe he wants to work with files on the server machine? 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.
Well, not all dbas are happy with homegrown C-code on the server.

Lots of Greetings!
Volker