Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Pb with stocked Procedure

Pb with stocked Procedure

From: Zemotard <nicolas.ponchel_at_orange.fr>
Date: Wed, 19 Sep 2001 17:36:32 +0200
Message-ID: <9oae1j$39t$1@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;

Received on Wed Sep 19 2001 - 10:36:32 CDT












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US