Dear sll, we are using oracle database 12c and oracle apex 4.2.
to send notification to end user via email, we want arabic date to be send to the users.
we have the following code, its sending arabic date just fine, but we are facing and error some time.
EXECUTE IMMEDIATE ' alter session set NLS_LANGUAGE=ARABIC';
select to_char(pdate, 'fmDay, fmDD fmMonth, YYYY') into arabic_date from dual;
EXECUTE IMMEDIATE 'alter session set NLS_LANGUAGE=AMERICAN';
time to time, we receive the following error
following is the debugging screen shot
how can we fix it?
Thanks.