How to use CALL stmt in sql
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: How to use CALL stmt in sql

  1. #1
    Join Date
    Mar 2004
    Location
    Chennai
    Posts
    1

    How to use CALL stmt in sql

    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

  2. #2
    Join Date
    Mar 2004
    Location
    Pakistan
    Posts
    5
    Please try these two:

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

    Good luck,
    Take care,
    Bye.
    To repeat what others have said, requires education; to challenge it, requires brains!

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width