How to use CALL stmt in sql
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.
Please try these two:
SQL> set SERVEROUPUT ON;
SQL> CALL dbms_java.set_output(1000);
To repeat what others have said, requires education; to challenge it, requires brains!
Click Here to Expand Forum to Full Width