delphi中调用oracle的存储过程.docVIP

- .-- 【delphi+oracle报表解决方案(一)】delphi中调用oracle的存储过程(分带返回游标，不返回值两种)? 关键字: delphi ,oracle存储过程，游标,返回数据集,报表注：delphi 6+ oracle 8.1.6一.创建包与包体1.附：建表aaclass为下面作测试用create table aaclass(CID VARCHAR2(50), CNAME VARCHAR2(50), pnumber NUMBER(10,0) );INSERT INTO aaclass values(c1, cn1, 10 ) ;INSERT INTO aaclass values(c2, cn2, 40 ) ;INSERT INTO aaclass values(c1, cn3, 30 ) ;commit;2.建包:CREATE OR REPLACE? PACKAGE PKG_JCCTEST1?????????????????????????? AS ? type rc_class is ref cursor;??????????????????? ? --求p1,p2的和与差，返回的多个值通过游标返回? procedure GetSubAndSum2(p1 number,p2? number ,?????