Toad Call stored procedure, stored procedure calls SQL class

1. Define a SQL class Hello

DROP JAVA SOURCE newxzxt. " Hello "; CREATE OR REPLACE and RESOLVE JAVA SOURCE NAMED newxzxt. " Hello "as import java.lang.*;    public class Hello    {public        static string say (String args)        {            System.out.println (args);            return args;        }    } /

2. The SQL class above the stored procedure call

CREATE OR REPLACE Procedure newxzxt.prc_hehe (       p_name VARCHAR2) aslanguage Java name ' Hello.say (java.lang.String) ';

3. Call the stored procedure

Set Serveroutput on;call prc_hehe (' Test ok! '); Call Dbms_java.set_output, call Prc_hehe (' Test ok! ');

　　

Toad Call stored procedure, stored procedure calls SQL class