23 avril 2009
tests
CREATE OR REPLACE PROCEDURE AddOrder (PIdclient IN oorder.IdClient%type, POrderDate IN oorder.OrderDate%type) IS BEGIN INSERT INTO oorder (IdO, IdClient, OrderDate, OrderState) VALUES (Seq_oorder.nextval, PIdclient, POrderDate, 'AT') ; END;/ EXECUTE AddOrder(1,...