Oracle in a Nutshell

PL/SQL in SQLJ

To call a PL/SQL procedure with SQLJ, use the following syntax:

#sql { CALL procedure_name([parameter_list])};

To call a PL/SQL function with SQLJ, use this syntax:

#sql host_variable = { VALUES (function_name([parameter_list])) }

If the return from a PL/SQL function is a REF CURSOR, the host_variable should be an iterator that matches the result set.

You can also use the SET command, discussed earlier, in SQLJ to receive data into host variables. In addition, you can include anonymous blocks of PL/SQL code within a SQLJ call.