Results 1 to 3 of 3
  1. #1
    Join Date
    Aug 2002
    Location
    Taiwan
    Posts
    2

    Unanswered: Error: Ora-00600

    Dear all:

    I write a test program using OCI API(library ver 9.0.1)on Solaris8,
    to access Oracle9i database on another Solaris8 platform.
    an error ORA-00600 occur...

    ERROR CODE = 600
    ORA-00600: internal error code, arguments: [kposcws0], [], [], [], [], [], [], []


    the table "test" has a "null" field "test_note" create in database,

    create table test("test_id number not null,"
    "test_name varchar2(30) not null,"
    "test_note varchar2(50) null,"
    "Constraint testPk Primary Key(test_id))

    and part of the test program as follows:

    text* sqlCmd= (text*)"SELECT * FROM test";
    OCIStmtPrepare(stmthp,errhp,sqlCmd,strlen((char*)s qlCmd),OCI_NTV_SYNTAX,OCI_DEFAULT);
    OCIStmtExecute(svchp,stmthp,errhp,0,0,NULL,NULL,OC I_STMT_SCROLLABLE_READONLY);

    int test_id = 0;
    char test_name[31] = "";
    char test_note[51] = "";

    OCIDefineByPos(stmthp,&defnp,errhp,1,&test_id,size of(int),SQLT_INT,0,0,0,OCI_DEFAULT);
    OCIDefineByPos(stmthp,&defnp,errhp,2,test_name,30, SQLT_STR,0,0,0,OCI_DEFAULT);
    OCIDefineByPos(stmthp,&defnp,errhp,3,test_note,50, SQLT_STR,0,0,0,OCI_DEFAULT);
    printf("TEST_ID\tTEST_NAME\tTEST_NOTE\n");
    printf("-------\t---------\t---------\n");
    bool o_flag = false;
    while(!o_flag){
    switch(OCIStmtFetch2(stmthp,errhp,1,OCI_FETCH_NEXT ,0,
    OCI_DEFAULT)){
    case OCI_NO_DATA:
    o_flag = true;
    break;
    case OCI_ERROR:
    report_error(errhp);
    o_flag = true;
    break;
    case OCI_SUCCESS:
    case OCI_SUCCESS_WITH_INFO:
    printf("%d\t%s\t%s\n",test_id,test_name,
    test_note);
    break;
    }
    }


    when I try to fetch a nullable field "test_note" with no data in it,
    internal error ORA-00600 occur:
    ERROR CODE = 600
    ORA-00600: internal error code, arguments: [kposcws0], [], [], [], [], [], [], []

    is there any idea to solve this problem,thanks.

  2. #2
    Join Date
    Oct 2002
    Location
    greenwich.ct.us
    Posts
    279
    ORA-600 Error messages should be reported to Oracle Support. Typically, they represent a bug that Oracle might have a patch for.

  3. #3
    Join Date
    Apr 2002
    Location
    California, USA
    Posts
    482

    Cool

    It has been reported bug regarding this error when fetching row with NULL in last column via OCISTMTFETCH2()) which you obviously have in your code:

    switch(OCIStmtFetch2(stmthp,errhp,1,OCI_FETCH_NEXT ,0,OCI_DEFAULT))

    Oracle suggests that suppose to be fixed in to be fixed in 9.0.1.2 version, but you better work with them to resolve it. If you have Oracle support log a TAR.


    Hope that helps,

    clio_usa
    OCP - DBA

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •