C#连接Oracle实例（含源码和数据库）

//添加商品 create or replace PROCEDURE ADDGOODS(goodsname in varchar2,fromid in number,num in number) AS BEGIN INSERT INTO GOODS(NAME,FROMID,NUM)VALUES (goodsname,fromid,num); END ADDGOODS; //提取所有商品 create or replace PROCEDURE ALLGOODS (p_CURSOR OUT TESTPACKAGE.Test_CURSOR) IS BEGIN OPEN p_CURSOR FOR SELECT * FROM GOODS,GOODSFROM where GOODS.FROMID=GOODSFROM.FROMID ; END ALLGOODS; //删除商品 create or replace PROCEDURE DELETEGOODS (gid in number) AS BEGIN delete from GOODS where GOODSID = gid; END DELETEGOODS; //提取供应商名称 create or replace PROCEDURE FROMNAME (p_CURSOR OUT TESTPACKAGE.Test_CURSOR) IS BEGIN OPEN p_CURSOR FOR SELECT * FROM GOODSFROM ; END FROMNAME; //模糊查询商品信息 create or replace PROCEDURE SELECTGOODS (p_CURSOR OUT TESTPACKAGE.Test_CURSOR,gname in varchar2) IS BEGIN OPEN p_CURSOR FOR SELECT * FROM GOODS,GOODSFROM WHERE NAME like '%'||gname||'%' ; END SELECTGOODS; //修改商品信息 create or replace PROCEDURE UPDATEGOODS (gid in number,goodsname in varchar2,fid in number ) AS BEGIN update GOODS set GOODS.NAME=goodsname,GOODS.FROMID=fid where GOODSID=gid; END UPDATEGOODS;