For languages other than 'AMERICAN' user defined function is returning error in first run.

 Hi Team,

I want to execute a function in a package as below from shell script. But for NLS_LANGUAGE other than 'AMERICAN' this is returning error in first run. When we run for second time it is working as expected.

For 'AMERICAN' it is working in the first run itself without issues.

Could you please advise?

Thanks,

Deepak

-----------------------------------------------------------------------------------------------------------------------------------------------------------------------

SQL> ALTER SESSION SET NLS_LANGUAGE='SIMPLIFIED CHINESE';

ä¼è¯

SQL> SELECT (APPS.GECM_RF_CTL_FILE_PKG.GECM_RF_CTL_FILE_CALL_FUN('5712707','$.FA X_SEQNO', '9014',29047)) FROM dual;

SELECT (APPS.GECM_RF_CTL_FILE_PKG.GECM_RF_CTL_FILE_CALL_FUN('5712707','$.FA X_SEQNO', '9014',29047)) FROM dual