Invoking a Java Stored Procedure using SQL

In SQL*Plus, you can execute the CALL statement interactively to invoke a Java stored procedure, using the syntax:




CALL [schema_name.][{package_name | object_type_name}][@dblink_name]



  { procedure_name ([param[, param]...])



    | function_name ([param[, param]...]) INTO :host_variable};

where param represents this syntax:




{literal | :host_variable}

Host variables, variables declared in a host environment, must be prefixed with a colon. The following examples show that a host variable
cannot appear twice in the same CALL statement, and that a subprogram with no parameters must be called with an empty parameter list:




CALL swap(:x, :x); -- illegal, duplicate host variables



CALL balance() INTO :current_balance; -- () required