How to use CALL stmt in sql

[Jagadeeswari]

Hi,

I created a java code and loaded to the database using loadjava command successfully.

I created a stored procedure and also compiled it to call the java method. But when I iisue the command CALL dbms_java.set_output(1000) from SQL prompt I get an error message as,
unknown command beginning "call dbms_..." - rest of line ignored.

Can anyone help me to solve this problem.

Thanks,
Jagadeeswari

[~*~ ®ø§ê ~*~]

Please try these two:

SQL> set SERVEROUPUT ON;
SQL> CALL dbms_java.set_output(1000);

Good luck,
Take care,
Bye.