ora 932, cant display the select column
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: ora 932, cant display the select column

  1. #1
    Join Date
    Oct 2002
    Posts
    391

    ora 932, cant display the select column

    SVRMGR> desc sapr3.dbtablog;
    Column Name Null? Type
    ------------------------------ -------- ----
    LOGDATE NOT NULL VARCHAR2(8)
    LOGTIME NOT NULL VARCHAR2(6)
    LOGID NOT NULL VARCHAR2(18)
    TABNAME NOT NULL VARCHAR2(30)
    LOGKEY NOT NULL VARCHAR2(250)
    HOSTNAME NOT NULL VARCHAR2(20)
    USERNAME NOT NULL VARCHAR2(12)
    TCODE NOT NULL VARCHAR2(20)
    PROGNAME NOT NULL VARCHAR2(40)
    OPTYPE NOT NULL VARCHAR2(1)
    DATALN NOT NULL NUMBER(5)
    LOGDATA LONG RAW
    SVRMGR> select * from sapr3.dbtablog where tabname like '%T028%';
    ORA-00932: inconsistent datatypes

    however, if i specify column instead of a *, there is no error of 932. Please advise.

  2. #2
    Join Date
    Nov 2002
    Location
    Geneva Switzerland
    Posts
    3,142
    I suspect that SVRMGR doesn't know how to deal with a LONG RAW.

    Why aren't you using SQL*Plus for this?

Posting Permissions

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



Click Here to Expand Forum to Full Width