Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Calling External Procedures
I forgot to add that I am using Oracle8 on solaris
and I am new to oracle.
Could I be missing something obvious?
Mark
Mark Intrieri wrote in message <74jmvg$rmh$1_at_news.dtgroup.com>...
>Hi,
>
>I've created an external procedure which I would like to call.
>The problem is that the database seem to freeze when I execute the
>procedure.
>
>I've issued the create library statement successfully.
>
>CREATE LIBRARY jr_mail AS '/usr/local/lib/libJRmail.so';
>
>I've successfully created a function.
>
>CREATE FUNCTION CREATE_ACCT(acct IN CHAR)
>RETURN BINARY_INTEGER AS EXTERNAL
>LIBRARY jr_mail
>NAME "accountCreate"
>LANGUAGE C;
>
>I've successfully created a stored procedure.
>
>CREATE PROCEDURE TEST(acct IN CHAR) IS
> rtn BINARY_INTEGER
>BEGIN
> rtn := CREATE_ACCT(acct);
>END;
>
>When I attempt to execute the TEST procedure, the SQL worksheet application
>freezes.
>
>Any ideas?
>
>Thanks in advance,
>Mark.
>
>
>
>
>
Received on Wed Dec 09 1998 - 12:11:39 CST