[SOLVED] How to send date for Oracle stored procedure
Hi Please help me to send date for oracle stored procedure. I am trying execute below stored procedure.
SQL SQLORA SET SERVER DEV_CONNECTION
SQL SQLORA EX DEV_REPORT.CLM_STATUS.SpReport '100000',TO_DATE('03012019','MMDDYYYY'),TO_DATE('04122019','MMDDYYYY'),'All';
-RUN
TABLE FILE SQLOUT
PRINT *
WHERE READLIMIT EQ 10
END
-RUN
This message has been edited. Last edited by: FP Mod Chuck,
WebFOCUS 8.2.01,windows 8,All Output Format
April 19, 2019, 08:30 AM
jfr99
Try this ...
SQL SQLORA EX DEV_REPORT.CLM_STATUS.SpReport '100000',20190301,20190412,'All';
or this ...
SQL SQLORA EX DEV_REPORT.CLM_STATUS.SpReport '100000','2019-03-01','2019-04-12','All';
WebFocus 8.201M, Windows, App Studio
April 20, 2019, 10:42 AM
Sowthri
Thank you jfr99, I tried both way. I got below error.
(FOC1400) SQLCODE IS 1843 (HEX: 00000733)
(FOC1500) : ORA-01843: not a valid month
(FOC1500) : ORA-06512: at "DEV_REPORT.CLM_STATUS", line 16
(FOC1500) : ORA-06512: at line 1
L (FOC1405) SQL PREPARE ERROR.