Hello all.
I'm facing a strange problem with the VS 2022 designer and reading parameters in simple stored procedures.
While in the "UPDATE" procedure, the designer can read the parameters, on the contrary the "SELECT" procedure cannot.
I am quoting the corresponding screnshots and the simplest package I am using.
Thank you in advance.
CREATE OR REPLACE PACKAGE PACK_ORDERS IS
/*---------------------------------------------------------------------------*/
PROCEDURE GET_ORDER
(
I_ORDER_NO IN NUMBER,
O_RES OUT SYS_REFCURSOR
);
/*---------------------------------------------------------------------------*/
PROCEDURE UPDATE_ORDER
(
I_ORDER_NO IN NUMBER,
I_ALTERNATEORDERNO IN VARCHAR2,
I_BARCODE IN VARCHAR2,
O_RES OUT NUMBER
);
END PACK_ORDERS;
/*---------------------------------------------------------------------------*/
CREATE OR REPLACE PACKAGE BODY PACK_ORDERS IS
/*---------------------------------------------------------------------------*/
PROCEDURE GET_ORDER
(
I_ORDER_NO IN NUMBER,
O_RES OUT SYS_REFCURSOR
)
IS
BEGIN
OPEN O_RES FOR
SELECT O.COMPANYID,
O.ORDERDATE,
O.CUSTOMERID,
O.ORDERNO,
O.ALTERNATEORDERNO,
O.BARCODE
FROM BIOFORMA.ORDERS O
WHERE O.ORDERNO = I_ORDER_NO;
END GET_ORDER;
/*---------------------------------------------------------------------------*/
PROCEDURE UPDATE_ORDER
(
I_ORDER_NO IN NUMBER,
I_ALTERNATEORDERNO IN VARCHAR2,
I_BARCODE IN VARCHAR2,
O_RES OUT NUMBER
)
IS
BEGIN
UPDATE BIOFORMA.ORDERS O
SET O.ALTERNATEORDERNO = I_ALTERNATEORDERNO,
O.BARCODE = I_BARCODE
WHERE O.ORDERNO = I_ORDER_NO;
COMMIT;
O_RES := 1;
EXCEPTION
WHEN OTHERS THEN
O_RES := 0;
END UPDATE_ORDER;
/*---------------------------------------------------------------------------*/
END PACK_ORDERS;
