PL/SQL procedure within a package

How can I use a store开发者_如何学JAVAd PACKAGE foo on the database using PL/SQL?

Say the package contains a PROCEDURE bar. How can I call it?

The procedure is called by ..

In SQL*Plus:

declare
begin
  foo.bar(par1, par2, par3);
end;

From odbc/jdbc you typically use the following SQL:

SQL_STRING = "{ call foo.bar(?, ?, ?) }"