Oracle SP
--------------------------------------------------------------------------------------------------------------------
CREATE OR REPLACE PROCEDURE RPT_MFS_Revised_Journal (
P_JOURNAL_DATE IN DATE := NULL,
cur_OUT IN OUT SYS_REFCURSOR)
AS
BEGIN
OPEN cur_out FOR
SELECT TO_CHAR (TransactionDate, 'DD/MM/YYYY') AS TransactionDate,
TXCODE,
FROM T_Activity,
WHERE ( (T_Activity.IsRollBack = 0)
OR (T_Activity.IsRollBack = 1
ORDER BY T_Activity.TxID;
END;
/
----------------------------------------------------------------------------------------------------------------------
Suppose
SP Name: RPT_MFS_Revised_Journal
Parameters:
P_JOURNAL_DATE : '10/25/2014'
To Debug SP Write Following Code
---------------------------------------------------------------------
BEGIN
RPT_MFS_Revised_Journal (
:P_JOURNAL_DATE,
:cur_OUT);
END;
---------------------------------------------------------------------
Select code and click [Execute statement] from left side {blue play button}
A Variables window popup. Select date type for [P_JOURNAL_DATE] and input date('10/25/2014') and null for [cur_OUT]
Then click OK.
If Everything ok, then you got actual result.
--------------------------------------------------------------------------------------------------------------------
CREATE OR REPLACE PROCEDURE RPT_MFS_Revised_Journal (
P_JOURNAL_DATE IN DATE := NULL,
cur_OUT IN OUT SYS_REFCURSOR)
AS
BEGIN
OPEN cur_out FOR
SELECT TO_CHAR (TransactionDate, 'DD/MM/YYYY') AS TransactionDate,
TXCODE,
FROM T_Activity,
WHERE ( (T_Activity.IsRollBack = 0)
OR (T_Activity.IsRollBack = 1
ORDER BY T_Activity.TxID;
END;
/
----------------------------------------------------------------------------------------------------------------------
Suppose
SP Name: RPT_MFS_Revised_Journal
Parameters:
P_JOURNAL_DATE : '10/25/2014'
To Debug SP Write Following Code
---------------------------------------------------------------------
BEGIN
RPT_MFS_Revised_Journal (
:P_JOURNAL_DATE,
:cur_OUT);
END;
---------------------------------------------------------------------
Select code and click [Execute statement] from left side {blue play button}
A Variables window popup. Select date type for [P_JOURNAL_DATE] and input date('10/25/2014') and null for [cur_OUT]
Then click OK.
If Everything ok, then you got actual result.
No comments:
Post a Comment