BUG when connecting to oracle 11g with scriptcase 9

Scriptcase 9 Bugs
#1

On my server I can connect to mariadb, sqlite and oracle normally use a commandline tool.
Creating apps works, but when an oracle connection is used we get dozens of errors. Please test under 64 bit scriptcase using instantclient 12.1 (64 bit).
By the way using sqlplus.exe I can connect with no problem whatsoever and using a simple mini php program using oci_connect I can also connect without problems…

You have left some serious bugs in the scriptcase code, is basically doesnt work in many occasions under oracle… FIX PLEASE!!:mad::mad::mad::mad:

#2

I had problems with SC9 vs Oracle 11.2. The connection was not possible. (I had that install Oracle 12 and it worked.)
SC Team must fix that errors.

#3

We are currently in discussion with Henrique about this issue. I hope it will be fixed too. We have sent a project that causes errors while generating code for oracle, but runs well if you generate the same code to mysql or mariadb. There are a few options. Since we can connect it’s an OCI issue, or it’s an issue in the sql parser somewhere. If you look into the generated code there are loads of case statments to do something differently depending on database.

#4

Aparently this still hasnt been fixed. I am testing using an oracl 11 client (64 bit) against scriptccase 64 bit. So far no luck. And of course I can login using the commandline so my oracle is good.
Time to test out oracle 12 client…

#5

And yes the oracle 12.1 and 12.2 instant clients seem to work as expected… So far so good… For people with the same problem… Do not use the instant client version Version 18.3.0.0.0 from https://www.oracle.com/technetwork/topics/winx64soft-089540.html or count with more difficulties (login.sql not found for example).
we have scriptase 8 (on 32 bit) and 9 on 64 bit running here (windows).
Time for more fiddling and finetuning…