RE: LEI Command - Connection to Oracle Berne Nyberg 26.Nov.15 01:20 PM a Web browser LEI LEI - All ReleasesWindows
Hi and thank you for your answer!
The Oracle client is also changed, to the latest version, but the connection is working, and I have a lot of activities that are running without problem, also Commands like this one with a call to a procedure, but I assume that they don't have any date or time format calls that could go wrong.
I have also rebuild the connection and activity, with no luck.
I had a Direct transfer that went wrong, but I solved that by using another syntax. I changed in the select statement from
S.TIMMAR (timmar is hours in Swedish) to CAST(S.TIMMAR as float) AS TIMMAR. After that the Direct transfer was successful, but in this failing Command I have nothing to change, it's a more simple call.
I have enabled the "Output SQL Statements to Log" option, but I don't get any more information. I wonder what IEI 9 send to Oracle in this simple call "BEGIN PDAGBOK.PLAN_API.UPP_JOBB; END;"?
Both LEI 7 and the new IEI 9 is connecting to same Oracle installation, Oracle XE 11g, and LEI 7 is working but not IEI 9, but if I connect to an older version I have, Oracle XE 10g, with a copy of the database, it's working perfect.
So something between IEI 9 and Oracle 11g is failing, depending on Oracle or IEI 9. Rebuilding the procedure in Oracle seems to be the only solution, but with over one thousand line of code in the procedure, it had been easier if there was any chance to make any change to the call from the command in IEI 9!
Return to top
. . . . RE: LEI Command - Connection to Ora... (Berne Nyberg 26.Nov.15)
Print this page
