We just update from 8.0.14 to 8.0.17 and now all applications during generation raise an error
“2 = ociexecute(): ORA-00942: table or view does not exist”
“…/www/scriptcase8/prod/third/adodb/drivers/adodb-oci8.inc.php 1039”
because the names of tables in the sc_lookup functions are written in lowercase and not in uppercase
You should seriously use only uppercase tables in oracle. We have our oracle tables in uppercase and in scriptcase we also have our tablenames in uppercase. It works quite fine that way.
Oracle lowercase tables. see here: http://docs.oracle.com/cd/B28359_01/server.111/b28286/sql_elements008.htm
In addition to that, people using MySQL can get similar issues as the table names are now case-sensitive.
This is nice to know.
Besides nice to know also the question pops up on why Scriptcase changed this?
In previous versions of SC there were no compiler errors on this subject. Why now?
Other development tools do not complain, when Oracle table-names are coded in lowercase. Oracle itself does not complain, when table-names are coded in lowercase. Oracle SQL-developer does not complain, when table-names are coded in lowercase.