Re: Pb with stocked Procedure

"Zemotard" <nicolas.ponchel_at_orange.fr> wrote in message news:9oae1j$39t$1_at_wanadoo.fr...
> I have this stocked procedure and i would like execute this with sql but i
> don't know the syntax.
> So i need a some help.
>
> thanks
>
> CREATE OR REPLACE PROCEDURE MAX_PROJET(nNum_Proj out integer)
> AS
> BEGIN
> select max(N_PROJET) into nNum_Proj from PROJET;
> exception when no_data_found then
> nNum_Proj:=0;
> END;
>
>
>

stocked procedure, very funny. It is stored procedure. The syntax is
declare
 numproj number;
begin
max_projet(numproj);
end;

in any tool

or
(in sql*plus)
variable numproj number
execute max_project(numproj)
print numproj

Hth,

Sybrand Bakker, Senior Oracle DBA Received on Wed Sep 19 2001 - 11:10:23 CDT