Calling an Oracle Stored Procedure from sqlplus
where the package is call calc and the function is called pricecp...
SQL> variable x number;
SQL> begin
2 :x := calc.pricecp (23, 'LCL', '1-apr-98', '1-apr-99');
3 end;
4 .
SQL> /
PL/SQL procedure successfully completed.
SQL> print x
X
----------
-4.4776119