OraFAQ Forum: SQL & PL/SQL » Date Parameter Issue

Home » SQL & PL/SQL » SQL & PL/SQL » Date Parameter Issue

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Date Parameter Issue [message #638819]

Mon, 22 June 2015 09:11

dilip.nnitw@gmail.com
Messages: 3
Registered: December 2012
Location: Hyderabad

Junior Member

Hi Friends,

I am Facing issues in Passing the values to the Concurrent Program which is based on Procedure with parameters -

The Concurrent Program Parameters are taken as character Type.

The procedure parameters are also defines as varchar;i am getting the error message as follows -
Cause: FDPSTP failed due to ORA-01847: day of month must be between 1 and last day of month
ORA-06512: at line 1

Can you pls guide on the issue.

Thanks In Advance!

Swapne Sree Nomula

Attachment: Sample.sql
(Size: 8.98KB, Downloaded 1576 times)

Report message to a moderator

Re: Date Parameter Issue [message #638820 is a reply to message #638819]

Mon, 22 June 2015 09:19

cookiemonster
Messages: 13975
Registered: September 2008
Location: Rainy Manchester

Senior Member

Stop using varchars for dates.

Report message to a moderator

Re: Date Parameter Issue [message #638832 is a reply to message #638820]

Mon, 22 June 2015 13:33

Bill B
Messages: 1971
Registered: December 2004

Senior Member

You have to put a TO_DATE around the P_GL_DATE_LOW and P_GL_DATE_high dates with the correct format string. For example

between to_date(P_GL_DATE_LOW,'MM/DD/YYYY') AND TO_DATE(P_GL_DATE_LOW,'MM/DD/YYYY')

Report message to a moderator

Re: Date Parameter Issue [message #638844 is a reply to message #638832]

Tue, 23 June 2015 04:13

dilip.nnitw@gmail.com
Messages: 3
Registered: December 2012
Location: Hyderabad

Junior Member

Thanks Bill,Its working!

Swapna!

Report message to a moderator

Previous Topic:	Design to Validate Staging records (merged)
Next Topic:	Substitute variable in script

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Jul 27 05:53:07 CDT 2026