Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> External Procedures & ODT in Oracle8
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