Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Message passing between host program and Database
What's about Pro*C? - You write a C-Crogram with included
(PL/)SQL-Statements. A Pre-Compiler will make a normal C-Program which you
can link with Oracle-Librarys to an executeable...
And for communication between Oracle and this C-Program you can use some
Oracle-Packages like: dbms_pipe, dbms_alert, dbms_aq (Oracle8 only). DML is
also possible with the dbms_sql package!
Andy,
Ing. Andreas Vogler
ETM Aktiengesellschaft
Kasernenstr. 29, A-7000 Eisenstadt
Tel. +43-2682-741-0, Fax-107
E-Mail: vogler_at_etm.at
Web: < <http://www.etm.at>>
usmrall schrieb in Nachricht <7mvv9l$632$1_at_nnrp1.deja.com>...
>Hello all,
>I am trying to find a way by which messages can be passed between a
>program on the Unix host and the database ?
>The external procedure method allows you to execute programs on the
>server-side,but can we use it to accept arguments and in turn do some
>DML etc in the database ?
>Any help will be appreciated.
>Thanks
>
>
>Sent via Deja.com http://www.deja.com/
>Share what you know. Learn what you don't.
>
Received on Tue Jul 20 1999 - 02:40:45 CDT