Story Category: OracleDB
VOTEODAC: 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
3 years ago in Database Development, Delphi, Development, OracleDB, Software Development
0
ODAC undocumented exception ‘Need Oracle 8 Call Interface’
jpluimers
I got this when taking over maintenance of some legacy code that called a stored procedure in a : ————————— Debugger Exception Notification ————————— Project LegacyProject.exe raised exception class Exception with message ‘Need Oracle 8… … Read more
3 years ago in Database Development, Delphi, Development, OracleDB, Software Development
0