Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> External Procedures & ODT in Oracle8

External Procedures & ODT in Oracle8

From: Peter Jones <peter.jones_at_richmond-hill.demon.co.uk>
Date: Tue, 2 Jun 1998 18:01:34 +0100
Message-ID: <896807286.8304.0.nnrp-11.c1ed9a88@news.demon.co.uk>


I'm looking at Oracle8's ORDBMS capabilities and in particular the ability to use external C procedures/functions to implement methods for object data types. Currently, this is a paper excercise with my feasability study based on the CDROM manuals ... you got to start somewhere! My ODT is going to contain some VARRAYS which I need to manipulate in various member functions. Some of these functions are very complex numerically and algorithmically and I want to implement them in external functions. Looking at the PL/SQL references it doesn't seem as though I can pass arrays or indeed anything more complex than basic SQL types - but looking at the OCI reference there is a lot of stuff about manipulating array types etc.

Does anyone (a) if its possible to pass arrays or other collections to external functions; (b) if so does the external function binding convert it to a C types or do you have to use all the OCI stuff, or (c) am I way out of it..

Thanks

Peter Jones Received on Tue Jun 02 1998 - 12:01:34 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US