PL/SQL (MOSC)

MOSC Banner

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

edited May 1, 2013 11:19PM in PL/SQL (MOSC) 4 commentsAnswered
 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

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center