Why Can't a Java Stored Procedure be Called?

From: rfk <rfk_at_exit109.com>
Date: Tue, 21 Nov 2000 19:52:18 -0500
Message-ID: <3A1B18C2.4C3FE0B5@exit109.com>

I have a Java Stored Procedure that has been properly published, but when I try to CALL it in sqlplus, I get a message stating there is no such function...viz:

call Concat('hello', 'world!');

sqlplus tells me there is no such function

The only way I can successfully invoke the Java Stored Procedure is in a begin/end block...viz:

variable s varchar(100);
begin
:s := Concat('hello ' , 'world!');
end;
print :s;

hello world prints, as expected. Why is that?

Thanks for any help! Received on Tue Nov 21 2000 - 18:52:18 CST