delphi Judge whether ref cursor is null

Discussion of open issues, suggestions and bugs regarding ODAC (Oracle Data Access Components) for Delphi, C++Builder, Lazarus (and FPC)
Post Reply
ghtx001
Posts: 2
Joined: Thu 13 Aug 2020 10:22

delphi Judge whether ref cursor is null

Post by ghtx001 » 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;

MaximG
Devart Team
Posts: 1822
Joined: Mon 06 Jul 2015 11:34

Re: delphi Judge whether ref cursor is null

Post by MaximG » Fri 28 Aug 2020 09:06

Thank you for the information. We will investigate the described issue and let you know the results shortly.

Post Reply