Re: Calling C Functions from Oracle 7 Stored Procedures

In article <1993Apr3.210534.1_at_vxcrna.cern.ch> roeber_at_cern.ch writes:
>In article <1993Apr2.185737.13862_at_bnr.ca>, hris_at_bnr.ca (Jason Lisenchuk) writes:
>> I'm interested in having a C function on a client call an Oracle 7 Stored
>> Procedure (i.e. a compiled SQL procedure stored on Oracle 7 Server) [that's the
>> easy part] *which in turn calls a C function on the server*. Any ideas (other
>> than communicating through a table)?
>
>There's supposedly going to be a product RSN called "Open Gateway,"
>which allows you to write programs that make 'other things' look like
>Oracle tables. This should allow you to do what you want -- write a
>value to one of your virtual tables, and your 'write' routine will be
>invoked by the server. Or something like that. Unfortunately, getting
>any information about this out of Oracle is like pulling teeth.
>
>There were also some tantalizing hints about some "Open" "System"
>having to do with the letters 'XA', but we haven't been able to get
>much information about that, either.
>
>--
>Frederick G. M. Roeber | CERN -- European Center for Nuclear Research
>e-mail: roeber_at_cern.ch or roeber_at_caltech.edu | work: +41 22 767 31 80
>r-mail: CERN/PPE, 1211 Geneva 23, Switzerland | home: +33 50 20 82 99
>--
>"Sorry, baby, I can't take you to the pizza joint tonight, I've got to go
>back to the lab and split the atom." -- Ayn Rand, "What is Romanticism?"

I would suggest you use the new "Database Pipes" feature of O7. Database pipes let you call C code from PL/SQL Procedures. I heard of a recent example of this where interoperability of Oracle and Sybase needed to be showm and since the Open Gateway isn't ready they used Database Pipes and it worked like a charm.

For simple calling of C functions, Database Pipes should be adequate. The Open Gateway, I think, is more likely suited to distributed systems, ad-hoc queries, automatic mapping of SQL and non-SQL dialects, etc.

• Dan

Daniel Druker
Anderson Graduate School of Management at UCLA                    

| Dan Druker                                                               |
| agsm mail 	: ddruker                                                  |
| internet 	: ddruker_at_agsm.ucla.edu                                    |
| oracle*mail	: unix:ddruker_at_agsm.ucla.edu                               |
----------------------------------------------------------------------------

Disclaimer: None. I'm a student now and I don't care what you think. Received on Mon Apr 05 1993 - 10:00:39 CEST