Help: Translation Oracle Workgroup Server to Personal Oracle

From: Pat <palipp_at_metronet.de>
Date: 1997/08/14
Message-ID: <01bca8ee$a55c3e60$6e66a8c0@pc486>#1/1

Help!
I have the following problem:

I want to install some tables and views created with SQL-Scripts under Personal Oracle 7.3.3.0.0. (Example: see appendix)

I have had no problems to install the same tables and views under Oracle Workgroup Server 7.3.2.3.1 and to grant some object privileges to user-roles on these views.

Under Personal Oracle 7.3.3.0.0 the system establishes the tables and views without errormessages, but announces the following error trying to grant privileges to user-roles on some of these views:

        ERROR at line 1: 
        ORA-00932: inconsistent datatypes

(Example: see appendix)

Is there somebody who knows this problem ? What's the reason of my problem ? What can I do ? Change some configuration parameters ? Change the SQL-Scripts ? How ?

Plattforms:
Windows NT 4.0 (german)
Personal Oracle 7.3.3.0.0
Oracle Workgroup Server 7.3.2.3.1                                          

Appendix: Error-Example

---

Tables

---

SQL> create table produkt
  2 (

  3  	 produkt_id  integer not null,
  4  	 kurztxt     varchar2 (30) not null,
  5  	 valid_flag  number (1) not null,
  6  	     primary key (produkt_id)

  7 );

Table created.  

create table produkt1
  2 (

  3  	     haupt_produkt_id integer not null,
  4  	     produkt_id      integer not null,
  5  	     primary key (haupt_produkt_id)

  6 );

Table created.

create table produkt2
  2 (

  3  	     teil_produkt_id integer not null,
  4  	     produkt_id      integer not null,
  5  	     teil_von_produkt_id integer not null,
  6  	     primary key (teil_produkt_id)

  7 );

Table created.

create table pr_txt
  2 (

  3  	 produkt_id  integer not null,
  4  	 sprach_id   integer not null,
  5  	 txt varchar2 (2000) not null,
  6  	 primary key (produkt_id, sprach_id)

  7 );

Table created.

Views:

---

create or replace view pr_struktur (

  2  	     clevel,
  3  	     produkt_id,
  4  	     kurztxt,
  5  	     txt,
  6  	     vater,
  7  	     valid_flag

  8 ) as
  9 select 0 clevel,pr.produkt_id cprodukt, pr.kurztxt tktxt,  10 nvl(dias.pr_text(pr.produkt_id),nvl(pr.kurztxt,' ')) ttxt, 0 cvater, pr.valid_flag cvflag
 11 from produkt pr
 12 where pr.produkt_id in (select produkt_id from produkt1)  13 union
 14 select tp.clevel clevel, pr.produkt_id cprodukt, pr.kurztxt tktxt,  15 nvl(dias.pr_text(pr.produkt_id),nvl(pr.kurztxt,' ')) ttxt,  16 tp.teil_von_produkt_id cvater, pr.valid_flag cvflag from

 17  	     produkt pr,
 18  	     (select level clevel,p2.teil_von_produkt_id, p2.produkt_id from
produkt2 p2
 19  	     start with p2.teil_von_produkt_id in (select p1.produkt_id from
produkt1 p1)
 20  	     connect by prior p2.produkt_id=p2.teil_von_produkt_id) tp
 21  		     where pr.produkt_id=tp.produkt_id

 22 ;

View created.

Grants:

---

SQL> grant select on dias.pr_struktur to dias_autor; grant select on dias.pr_struktur to dias_autor

                                             *

ERROR at line 1:
ORA-00932: inconsistent datatypes   

---

---

Thank you

Pat Received on Thu Aug 14 1997 - 00:00:00 CDT