On Fri, July 10, 2009 08:41, Brock wrote: > > Vendor code: 1861 > > On Jul 9, 7:16 pm, Rob Wolfe <wolfe....@gmail.com> wrote: >> On Jul 9, 4:56 pm, Brock <wade.br...@yahoo.com> wrote: >> >> > I have some date in Oracle that are stored in this format 5/13/2008 >> > 11:10:53 AM ... I'm trying pass a variable into Oracle from a Crystal >> > Report... I'm using "and trunc(b.create_time) = to_date(p_date, 'DD- >> > Mon-YYYY');" but I keep getting "Failed to retrieve data from the >> > database"... any formatting ideas? Thanks! >> >> IIRC Crystal Reports also gives the vendor specific error code. What >> is being returned? >> >> Rob
http://www.bing.com/search?q=ora-01861 (stupid company has bing set up as our default search engine) Your format string is incorrect. If your "date" is indeed a text field, which it sounds as if might be, then your format must match ALL of the field. Alternately the format of p_date could be incorrect. Whenever I am going to embed sql in another application I always test it first in PL/SQL Developer (my personal fave, some like toad, some like good old fashioned sqlplus). This way i get rid of one possible source of error Rob --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Oracle PL/SQL" group. To post to this group, send email to Oracle-PLSQL@googlegroups.com To unsubscribe from this group, send email to oracle-plsql-unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/Oracle-PLSQL?hl=en -~----------~----~----~----~------~----~------~--~---
