ODAC: calling SYS.DBMS_SESSION.SET_NLS failing with ORA-06550/PLS-00103

[DP News-Robot]

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 of the bold portions in this call (note it contains the an instantiation of an [Archive.is] TOraSession Class as you […]

Weiterlesen...