Call a shared library with PL/SQL
Posted on 2009-07-09
i have a provided shared library which i need to call from within an PL/SQL procedure.
i got the the following from the vendor:
int functionxy( int arg0, int arg1, time_t arg2, const char *arg3, size_t arg4, char *arg5 )
so i'm not sure how to create/define the procedure in oracle, i was thinking of something like this:
CREATE OR REPLACE FUNCTION myFunction
(arg0 IN PLS_INTEGER,
arg1 IN PLS_INTEGER,
arg2 IN PLS_INTEGER,
arg3 IN CHAR,
arg5 IN OUT CHAR)
RETURN PLS_INTEGER AS LANGUAGE C
does this look correct so far? i'm really unsure on how to use the time_t type...
any help is appreciated.