oracle 12c
using sql developer
1)How to input a date value to the following pl/sql block?in what format do i give date? when i input value as TO_DATE('020413','mmddyy')
i get error.
2)when i run the following pl/sql block as run script i get error p_Ledger_To_Date not declared.
I have written a pl sql block
DECLARE
p_Customer_ID Number(5,0);
p_Dealer_ID Number(5,0);
p_Ledger_From_Date DATE;
p_Ledger_To_Date DATE;
Begin
SELECT 1 LEDGER_DISPLAY_SEQ,
'' TRANSACTION_DATE,
'TOTAL' PARTICULARS,
'' REFERENCE_OR_PO_NUMBER,
'' INVOICE_NUMBER_OR_BANK_NAME,
'' VOUCHER_TYPE,
SUM(DlrLgr.DEBIT_AMOUNT) DEBIT_AMOUNT,
SUM(DlrLgr.CREDIT_AMOUNT) CREDIT_AMOUNT,
SUM(DlrLgr.BALANCE_AMOUNT)BALANCE_AMOUNT
FROM ACCOUNTING_DEALER_LEDGER DlrLgr
WHERE DlrLgr.DEALER_ID = :p_Dealer_ID
AND DlrLgr.CUSTOMER_ID = :p_Customer_ID
AND DlrLgr.TRANSACTION_DATE BETWEEN :p_Ledger_From_Date AND :p_Ledger_To_Date
GROUP BY DEALER_ID,CUSTOMER_ID;
EXCEPTION
WHEN OTHERS THEN
DBMS_OUTPUT.PUT_LINE("Error Occured");
END