I’m using TOAD for Oracle V9.7.2.5
Oracle 8i
I’m trying to use Debug to “Run to Cursor”
The code is as follows:
CREATE OR REPLACE PACKAGE MOSES.PKG_RPT_SALES_08
AS
TYPE RPT_SALES_08_CURSOR IS REF CURSOR;
FUNCTION GetQuoteInvoicedTotal(v_OSNO IN NUMBER,
v_INVOICE_NO IN NUMBER)
RETURN NUMBER;
PROCEDURE PROC_RPT_SALES_08 (v_Org_ID IN NUMBER,
v_OSNo IN NUMBER,
v_Cust_No IN NUMBER,
v_From_Date IN VARCHAR2,
v_To_Date IN VARCHAR2,
RTN_CURSOR OUT RPT_SALES_08_CURSOR,
v_ERROR_CODE OUT VARCHAR2);
CREATE OR REPLACE PACKAGE BODY MOSES.PKG_RPT_SALES_08 AS
–