cancel
Showing results for 
Search instead for 
Did you mean: 

SP2-0678: Column or attribute type can not be displayed by SQL*Plus

Former Member
0 Kudos

Hi.

During th einstallation of solution manager, the table REPOSRC had the primary index not created because of duplicate keys (unknown reason)

Following Note 23237 we try to execute this select for identifying the duplicate keys, but the error SP2-0678 occurs.

Does anybody know how to solve it?

SQL> select alldata.rowid, alldata.*

2 from REPOSRC alldata,

3 (select PROGNAME, R3STATE

4 from REPOSRC

5 GROUP BY PROGNAME, R3STATE

6 HAVING COUNT(*) > 1) keydata

7 where alldata.PROGNAME=keydata.PROGNAME

8 and alldata.R3STATE=keydata.R3STATE;

SP2-0678: Column or attribute type can not be displayed by SQL*Plus

SQL>

Kind regards

Dino

Accepted Solutions (1)

Accepted Solutions (1)

stefan_koehler
Active Contributor
0 Kudos

Hello Dino,

> SP2-0678: Column or attribute type can not be displayed by SQL*Plus

Let's take a look at the table definition


SQL> desc SAPSR3.REPOSRC ;
 Name                                      Null?    Type
 ----------------------------------------- -------- ----------------------------
 PROGNAME                                  NOT NULL VARCHAR2(120)
 R3STATE                                   NOT NULL VARCHAR2(3)
...
...
 MAXLINELN                                 NOT NULL NUMBER(5)
 DATA                                               BLOB

The problem in your case is that the table REPOSRC has a BLOB column. In this case you get an SP2-0678 by running a query with "alldata.*".

To solve this issue just select the key columns with data type VARCHAR2 (or any other column but not DATA) and it should work:


SQL> select alldata.rowid, alldata.PROGNAME, alldata.R3STATE
from REPOSRC alldata,
(select PROGNAME, R3STATE
from REPOSRC
GROUP BY PROGNAME, R3STATE
HAVING COUNT(*) > 1) keydata
where alldata.PROGNAME=keydata.PROGNAME
and alldata.R3STATE=keydata.R3STATE;

Regards

Stefan

Answers (0)