Home » Developer & Programmer » Application Express, ORDS & MOD_PLSQL » NLS_CALENDAR problem (10.2.0.1,apex 3.1)
NLS_CALENDAR problem [message #336403] Sat, 26 July 2008 08:17 Go to next message
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,
Re: NLS_CALENDAR problem [message #336404 is a reply to message #336403] Sat, 26 July 2008 09:05 Go to previous messageGo to next message
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?
Re: NLS_CALENDAR problem [message #336407 is a reply to message #336404] Sat, 26 July 2008 09:15 Go to previous messageGo to next message
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 Go to previous messageGo to next message
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)!
Re: NLS_CALENDAR problem [message #336410 is a reply to message #336409] Sat, 26 July 2008 09:33 Go to previous messageGo to next message
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.
Re: NLS_CALENDAR problem [message #336411 is a reply to message #336410] Sat, 26 July 2008 09:45 Go to previous messageGo to next message
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?
Re: NLS_CALENDAR problem [message #336415 is a reply to message #336403] Sat, 26 July 2008 10:08 Go to previous message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
You have to use 2 simple quotes and not 1 double quote in the second statement.

Regards
Michel
Previous Topic: BROWSE FILE ITEM
Next Topic: java packages
Goto Forum:
  


Current Time: Thu Mar 28 03:37:37 CDT 2024