Joined: 12 Oct 2009
Location: Israel
Online Status: Offline
Posts: 1
Topic: ERROR , ORA-01843 Posted: 29 Oct 2009 at 2:55am
hi , i'm calling to my db function with date parameter from crystal reports and getting
ORA-01834 :NOT A VALID MONTH error , i tried to change to any format (dd/mm/yyyy,dd-mon-yyyy,dd-mmm-yy and go on....) but still getting this error , please if anybody knows how to resolve this problem ill be glad to hear some advices , thanks
Joined: 20 Nov 2006
Online Status: Offline
Posts: 3702
Posted: 29 Oct 2009 at 12:10pm
Does your function look for a date type or a string? Do you have the date parameter in Crystal set up as the same type as what the function is looking for?
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot delete your posts in this forum You cannot edit your posts in this forum You cannot create polls in this forum You cannot vote in polls in this forum