jpluimers
Do not call SYS.DBMS_SESSION.SET_NLS with an instance of the [Archive.is] TOraStoredProc Class, as under the hood, it will translate the call to this: Class:Ora.TOraStoredProc;Component:sprSetNls;Flag:tfQPrepare,Text:Prepare: begin SYS.DBMS_SESSION.SET_NLS(:PARAM, :VALUE); end; :PARAM(VARCHAR[22],IN)=’NLS_NUMERIC_CHARACTERS’ :VALUE(VARCHAR[4],IN)=”.,” The above is a translation… … Read more
4 years ago in Database Development, Delphi, Development, OracleDB, Software Development
0
ODAC: calling SYS.DBMS_SESSION.SET_NLS failing with ORA-06550/PLS-00103
jpluimers
Do not call SYS.DBMS_SESSION.SET_NLS with an instance of the [Archive.is] TOraStoredProc Class, as under the hood, it will translate the call to this: Class:Ora.TOraStoredProc;Component:sprSetNls;Flag:tfQPrepare,Text:Prepare: begin SYS.DBMS_SESSION.SET_NLS(:PARAM, :VALUE); end; :PARAM(VARCHAR[22],IN)=’NLS_NUMERIC_CHARACTERS’ :VALUE(VARCHAR[4],IN)=”.,” The above is a translation… … Read more
4 years ago in Database Development, Delphi, Development, OracleDB, Software Development
0
Leave Your Comment