Calling External Procedures

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 Tue Dec 08 1998 - 12:24:22 CST