OraFAQ Forum: Application Express, ORDS & MOD_PLSQL » NLS

Home » Developer & Programmer » Application Express, ORDS & MOD_PLSQL » NLS_CALENDAR problem (10.2.0.1,apex 3.1)

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

NLS_CALENDAR problem [message #336403]

Sat, 26 July 2008 08:17

pmapc
Messages: 46
Registered: July 2008

Member

Hi,

putting this lines of code in Edit Security Attributes-->Virtual Private Database (VPD)

begin
execute immediate
'alter session set NLS_CALENDAR="PERSIAN"';
execute immediate
'alter session set NLS_DATE_FORMAT="DD/MM/YYYY"';
end;

and Browse file item in my page give me the following error message:

ORA-01861: literal does not match format string

Any idea about why the reason of this problem?

Thanks,

Report message to a moderator

Re: NLS_CALENDAR problem [message #336404 is a reply to message #336403]

Sat, 26 July 2008 09:05

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

http://www.orafaq.com/forum/t/88153/0/
Please read & follow Posting Guideline as stated in URL above

Nobody can solve you mystery, until after you post the code which produces this error.

You have the tables.
You have the data.
You have the code & can't resolve it.
We have none of these.
Why do you expect miracles?

Report message to a moderator

Re: NLS_CALENDAR problem [message #336407 is a reply to message #336404]

Sat, 26 July 2008 09:15

pmapc
Messages: 46
Registered: July 2008

Member

I don't know why you thought I expect miracle.I think my description is crystal clear!!! Shocked

When I put the mentioned code in the Edit Security Attributes page(in Virtual Private Database (VPD) section) in apex, I get the mentioned error in all the pages that I have BROWSE FILE item and a SUBMIT buttom to browse my files and when I remove this lines of code everything works.

NOTHING MORE THAN THIS!!!

[Updated on: Sat, 26 July 2008 09:16]

Report message to a moderator

Re: NLS_CALENDAR problem [message #336409 is a reply to message #336403]

Sat, 26 July 2008 09:24

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

>I think my description is crystal clear!!!
You don't know, what you don't know.

Unless or until you post the actual code which works OK or throws errors, You're On Your Own (YOYO)!

Report message to a moderator

Re: NLS_CALENDAR problem [message #336410 is a reply to message #336409]

Sat, 26 July 2008 09:33

pmapc
Messages: 46
Registered: July 2008

Member

I think you need to read this link to be more polite: http://www.orafaq.com/forum/t/88153/0/
If you can not help or ask what you need to know please don't offense.

Report message to a moderator

Re: NLS_CALENDAR problem [message #336411 is a reply to message #336410]

Sat, 26 July 2008 09:45

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

pmapc wrote on Sat, 26 July 2008 07:33

I think you need to read this link to be more polite: http://www.orafaq.com/forum/t/88153/0/
If you can not help or ask what you need to know please don't offense.

Do you feel better now?
Are you closer to solving your mystery?
some/many/most folks can not debug code they can not see.
You can can not solve this problem even when seeing the code.

>ORA-01861: literal does not match format string
Above is explicitly clear as to what is wrong.
The code contains a literal which does not match your new format.

Some folks are clue resistant.
Other are clue repellent.
Which are you?

Report message to a moderator

Re: NLS_CALENDAR problem [message #336415 is a reply to message #336403]

Sat, 26 July 2008 10:08

Michel Cadot
Messages: 68731
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

You have to use 2 simple quotes and not 1 double quote in the second statement.

Regards
Michel

Report message to a moderator

Previous Topic:	BROWSE FILE ITEM
Next Topic:	java packages

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Jan 22 13:42:57 CST 2025