Menu

#26 OCI_SetFetchMode(st, OCI_SFM_SCROLLABLE);

v1.0_(example)
open
nobody
None
1
2014-01-17
2014-01-15
Anonymous
No

I try to modify the SQL in the test_scrollable_cursor function of demo.cpp, ora-0600 returned error

OCI_ExecuteStmt(st, MT("select table_name, table_name name from user_tables where ")
MT("table_name like 'TEST_%' order by table_name"));

Discussion

  • Anonymous

    Anonymous - 2014-01-15

    Additional, test environment, 10g no problem.

    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

     
  • Vincent Rogier

    Vincent Rogier - 2014-01-16

    Can you give more details ?

     
  • Anonymous

    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

    TEST SCROLLABLE CURSORS

    Total rows : 8

    CREATE TABLES FOR DEMO

    DROPPING TABLES AND TYPES

    ERROR : ORA-00600: internal error code, arguments: [17182], [0xE95A808], [], [], [], [],
    [], [], [], [], [], []

    ERROR : Found 2 unfreed OCI handle

    Press any key to exit...

     
  • brave man

    brave man - 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

    TEST SCROLLABLE CURSORS

    Total rows : 8

    CREATE TABLES FOR DEMO

    DROPPING TABLES AND TYPES

    ERROR : ORA-00600: internal error code, arguments: [17182], [0xE95A808], [], [], [], [],
    [], [], [], [], [], []

    ERROR : Found 2 unfreed OCI handle

    Press any key to exit...

     
  • brave man

    brave man - 2014-01-17

    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"));

     
Want the latest updates on software, tech news, and AI?
Get latest updates about software, tech news, and AI from SourceForge directly in your inbox once a month.