OraFAQ Forum: Reports & Discoverer » literal does not match format string

Home » Developer & Programmer » Reports & Discoverer » literal does not match format string (oracle9i)

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

literal does not match format string [message #409364]

Mon, 22 June 2009 05:53

aiyaz_ma
Messages: 56
Registered: May 2009
Location: Hyderabad

Member

Begin
select to_charto(date(p_date,'MM/DD/RRRR HH:MI:SS AM')) into x_date from dual;
--select to_char(to_date(trunc(p_date),'RRRR/MM/DD HH24:MI:SS')) into x_date from dual;
DISPLAY_MESSAGES('log','After converting the date formats ------>'|| x_date);
Exception
When others then
DISPLAY_MESSAGES('log','Failed in converting dates ------>'||p_date);
DISPLAY_MESSAGES('log',sqlerrm);
End;

Getting error while passing parameter date to p_date
Kindly help me

Thank you
Aiyaz

Report message to a moderator

Re: literal does not match format string [message #409367 is a reply to message #409364]

Mon, 22 June 2009 05:58

aiyaz_ma
Messages: 56
Registered: May 2009
Location: Hyderabad

Member

Begin
select to_char(to_date(p_date,'DD-MON-YYYY')) into x_date from dual;
--select to_char(to_date(trunc(p_date),'RRRR/MM/DD HH24:MI:SS')) into x_date from dual;
DISPLAY_MESSAGES('log','After converting the date formats ------>'|| x_date);
Exception
When others then
DISPLAY_MESSAGES('log','Failed in converting dates ------>'||p_date);
DISPLAY_MESSAGES('log',sqlerrm);
End;

Report message to a moderator

Re: literal does not match format string [message #409393 is a reply to message #409364]

Mon, 22 June 2009 07:40

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

Senior Member

Presumably p_date is not in the format DD-MON-YYYY.
So what is the datatype of p_date?
What value do you pass in for p_date?
What is the datatype of x_date?

Report message to a moderator

Re: literal does not match format string [message #409495 is a reply to message #409393]

Mon, 22 June 2009 23:08

aiyaz_ma
Messages: 56
Registered: May 2009
Location: Hyderabad

Member

thanks for the reply

The issue got cleared. As i have taken p_date data type as date which has to be varchar2.

thanks
Aiyaz

Report message to a moderator

Re: literal does not match format string [message #410313 is a reply to message #409393]

Fri, 26 June 2009 02:32

aiyaz_ma
Messages: 56
Registered: May 2009
Location: Hyderabad

Member

Hi

Can we only see items that have changed +/- 20% from the prior week. From what you said it should only print differences of over 20% plus or minus, but I'm seeing some that are the same quantity as the prior week.

Attached the Package Kindly help me in doing these changes

please give me some ideas

Thanks
Aiyaz

Attachment: HOPE_OE_EXCEPTION_RPT_PKG.pkb
(Size: 7.03KB, Downloaded 1288 times)

Report message to a moderator

Previous Topic:	Error A READ-ONLY bind variable used in OUT or IN-OUT context
Next Topic:	Column name as parameter

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Jan 23 15:27:23 CST 2025