| Date format and calendar type are not changing in oracle form [message #529243] |
Sun, 30 October 2011 04:02  |
zabltn
Messages: 45
Registered: September 2011
|
Member |
|
|
[EDITED by LF]
Please, do not move this topic back to Forms forum. This is what he had tried so far, but didn't manage to solve the problem. Therefore, I suggested to ask for help in Server Administration forum. Hopefully, someone will be able to assist.
Hi to all,
i have changed date's format and the calendar type in sqlplus
through the following command so the date's format and the calender type both changed successfully and work, but in oracle form the they haven't changed. your help will be my pleasure.
alter session set nls_calendar='persian';
ALTER SESSION SET NLS_DATE_FORMAT='YYYY/MM/DD';
ALTER SYSTEM SET NLS_DATE_FORMAT='YYYY/MM/DD' SCOPE=SPFILE;
Note: i know session would change the format temporally but i want to change it permanently so i tried alter_system but still no result
[Updated on: Sun, 30 October 2011 14:35] by Moderator Report message to a moderator |
|
|
|
|
|
| Re: Date format and calendar type are not changing in oracle form [message #529286 is a reply to message #529284] |
Sun, 30 October 2011 15:24  |
zabltn
Messages: 45
Registered: September 2011
|
Member |
|
|
Yes, client/server form.
The point is that why the changes in sqlplus are not effecting on oracle form, as i changed some settings in sqlplus then it works just for the sqlplus but it is not working in form, i mean if we change the date format in sqlplus then it should be change in forms also, but here it doesnot effect.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
