OraFAQ Forum: Application Express, ORDS & MOD

Home » Developer & Programmer » Application Express, ORDS & MOD_PLSQL » persian calendar

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

persian calendar [message #667241]

Sun, 17 December 2017 00:52

mehr
Messages: 3
Registered: October 2017

Junior Member

Hi Friends
I work on apex.I have a region that type is calendar.
I want This calendar be in persian calendar.my boss doesn't want change database nls so I just can change apex nls.
I change nls in Shared Components>>security>>database session with this code:

BEGIN
EXECUTE immediate 'ALTER SESSION SET NLS_CALENDAR=PERSIAN';
EXECUTE immediate 'ALTER SESSION SET NLS_DATE_FORMAT=''YYYY/MM/DD''';
END;

but it doesn't work.
I'm new in apex.can you help me please?
Thanks

Report message to a moderator

Re: persian calendar [message #667242 is a reply to message #667241]

Sun, 17 December 2017 01:16

John Watson
Messages: 8988
Registered: January 2010
Location: Global Village

Senior Member

Moderator note: this topic appears to come from an address used by an anonymous proxy server.

Report message to a moderator

Re: persian calendar [message #667243 is a reply to message #667242]

Sun, 17 December 2017 06:11

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

Senior Member
Account Moderator

The IP is registered to Hurricane Electric, Fremont, CA, USA; the request most likely comes from behind a firewall/proxy server (which could be an enterprise one).
Note that OP did not feedback in his previous topic.

Report message to a moderator