L
lion_fenn
Unregistered / Unconfirmed
GUEST, unregistred user!
我想建一个过程,通过前台的delphi传来一个参数条件,然后再返回数据集,这个过程该怎么写?
参数怎么传递?我写了一个,编译不成功:
CREATE OR REPLACE PACKAGE TypeDefine
AS
TYPE Cursor_Test IS REF CURSOR RETURN local_cdr1%ROWTYPE;
END;
CREATE OR REPLACE PROCEDURE sp_test
(msno IN char,resultData IN OUT TypeDefine.Cursor_Test)
AS
BEGIN
OPEN resultData FOR
SELECT msisdn,other_party from local_cdr1
where msisdn=msno;
END;
参数怎么传递?我写了一个,编译不成功:
CREATE OR REPLACE PACKAGE TypeDefine
AS
TYPE Cursor_Test IS REF CURSOR RETURN local_cdr1%ROWTYPE;
END;
CREATE OR REPLACE PROCEDURE sp_test
(msno IN char,resultData IN OUT TypeDefine.Cursor_Test)
AS
BEGIN
OPEN resultData FOR
SELECT msisdn,other_party from local_cdr1
where msisdn=msno;
END;