Focal Point Banner
Community Center Education Summit Technical Support User Groups
Let's Get Social!

Facebook Twitter LinkedIn YouTube
Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [SOLVED] How to send date for Oracle stored procedure
Go
New
Search
Notify
Tools
Reply
  
[SOLVED] How to send date for Oracle stored procedure
 Login/Join
 
Member
posted
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
 
Posts: 11 | Registered: February 23, 2016Reply With QuoteReport This Post
Platinum Member
posted Hide Post
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
 
Posts: 221 | Location: Lincoln Nebraska | Registered: August 12, 2008Reply With QuoteReport This Post
Member
posted Hide Post
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.



WebFOCUS 8.2.01,windows 8,All Output Format
 
Posts: 11 | Registered: February 23, 2016Reply With QuoteReport This Post
Virtuoso
posted Hide Post
Sowthri

This is an oracle error.. See this post I googled to resolve it. https://www.codeproject.com/Ti...-Month-Error-with-Or


Thank you for using Focal Point!

Chuck Wolff - Focal Point Moderator
WebFOCUS 7x and 8x, Windows, Linux All output Formats
 
Posts: 1603 | Location: Customer Support | Registered: April 12, 2005Reply With QuoteReport This Post
  Powered by Social Strata  
 

Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [SOLVED] How to send date for Oracle stored procedure

Copyright © 1996-2018 Information Builders, leaders in enterprise business intelligence.