December 2002
Intermediate to advanced
928 pages
85h 29m
English
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:
#sqlhost_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.