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

Delphi-PRAXiS (https://www.delphipraxis.net/forum.php)

- Delphi-News aus aller Welt (https://www.delphipraxis.net/58-delphi-news-aus-aller-welt/)

- - ODAC: calling SYS.DBMS_SESSION.SET_NLS failing with ORA-06550/PLS-00103 (https://www.delphipraxis.net/208133-odac-calling-sys-dbms_session-set_nls-failing-ora-06550-pls-00103-a.html)

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

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 […]