If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Anonymous
-
2014-01-17
OCILIB BUILD INFORMATION
OCI import mode : RUNTIME
MetaData char type : ANSI
UserData char type : ANSI
VERSIONS INFORMATION
OCILIB major version : 4
OCILIB minor version : 0
OCILIB revision version : 0
OCI compile version : 12
OCI runtime version : 10
Server major version : 11
Server minor version : 2
Server revision version : 0
Connection version : 1020
SERVER VERSION BANNER
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
OCI import mode : RUNTIME
MetaData char type : ANSI
UserData char type : ANSI
VERSIONS INFORMATION
OCILIB major version : 4
OCILIB minor version : 0
OCILIB revision version : 0
OCI compile version : 12
OCI runtime version : 10
Server major version : 11
Server minor version : 2
Server revision version : 0
Connection version : 1020
SERVER VERSION BANNER
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
Additional, test environment, 10g no problem.
OCI import mode : RUNTIME
MetaData char type : ANSI
UserData char type : ANSI
OCILIB major version : 4
OCILIB minor version : 0
OCILIB revision version : 0
OCI compile version : 12
OCI runtime version : 10
Server major version : 11
Server minor version : 2
Server revision version : 0
Connection version : 1020
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
Can you give more details ?
OCI import mode : RUNTIME
MetaData char type : ANSI
UserData char type : ANSI
OCILIB major version : 4
OCILIB minor version : 0
OCILIB revision version : 0
OCI compile version : 12
OCI runtime version : 10
Server major version : 11
Server minor version : 2
Server revision version : 0
Connection version : 1020
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
Total rows : 8
Press any key to exit...
OCI import mode : RUNTIME
MetaData char type : ANSI
UserData char type : ANSI
OCILIB major version : 4
OCILIB minor version : 0
OCILIB revision version : 0
OCI compile version : 12
OCI runtime version : 10
Server major version : 11
Server minor version : 2
Server revision version : 0
Connection version : 1020
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
Total rows : 8
Press any key to exit...
Failure position in the OCISessionEnd (con->cxt, con->err, con->ses, (UB4) OCI_DEFAULT).
The following SQL is correct:
st.Execute(MT("select table_name, table_name || '' name from user_tables where ")
MT("table_name like 'TEST_%' order by table_name"));