Enterprise Computing
Tuesday, November 15, 2005
  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

 




<< Home
Alistair Thomas's 'everything to do with enterprise computing'.

Archives
03/01/2004 - 04/01/2004 / 04/01/2004 - 05/01/2004 / 05/01/2004 - 06/01/2004 / 08/01/2004 - 09/01/2004 / 03/01/2005 - 04/01/2005 / 04/01/2005 - 05/01/2005 / 06/01/2005 - 07/01/2005 / 08/01/2005 - 09/01/2005 / 09/01/2005 - 10/01/2005 / 11/01/2005 - 12/01/2005 / 02/01/2010 - 03/01/2010 / 06/01/2013 - 07/01/2013 /


Powered by Blogger

Subscribe to
Posts [Atom]