delphi Judge whether ref cursor is null
Posted: Thu 13 Aug 2020 10:33
How to determine the OUT parameter returned to null in the oracle stored procedure
CREATE OR REPLACE PROCEDURE P_YB_PRINT_INVOICE(AS_CZLX VARCHAR2, AR_HZB OUT SYS_REFCURSOR) AS
BEGIN
If AS_CZLX = '0' Then
Return;
End IF;
OPEN AR_HZB FOR
SELECT * FROM tidentity where codeno = AS_CZLX;
END;
CREATE OR REPLACE PROCEDURE P_YB_PRINT_INVOICE(AS_CZLX VARCHAR2, AR_HZB OUT SYS_REFCURSOR) AS
BEGIN
If AS_CZLX = '0' Then
Return;
End IF;
OPEN AR_HZB FOR
SELECT * FROM tidentity where codeno = AS_CZLX;
END;