oracle - question

From: Mateusz Kłos <M.Klos_at_ifs.com.pl>
Date: Fri, 12 Mar 1999 12:56:33 GMT
Message-ID: <5a8G2.681$O1.79685@news.tpnet.pl>

Hi everybody!

I have observed a very strange sytuation:

Given is a view as follows:

CREATE OR REPLACE VIEW GEN_LED_VOUCHER_ROW_UNION_QRY AS

SELECT   .              .


                .                                                  .


                .                                                  .


             VRT.ROWID                                OBJID,
                .           .


                .                                                  .


                .                                                  .

FROM gen_led_voucher_row_tab VRT
WHERE <warunek>
UNION ALL

SELECT   .                      .


                .                                                  .


                .                                                  .


             VRT.ROWID                              OBJID,
                .             .
                .                                                 .
                .                                                 .

FROM voucher_row_tab VRT, voucher_tab VT WHERE <warunek>
WITH read only;

A query

   SELECT OBJID FROM GEN_LED_VOUCHER_ROW_UNION_QRY    gives as the result: 00007866.0000.0006

But a query:

   SELECT OBJID FROM GEN_LED_VOUCHER_ROW_UNION_QRY         WHERE OBJID = '00007866.0000.0006' rises an error: ORA-80103: Objest already exists (!!!!)

It is a very strange sytuation. I susspect, that the reason for this is a "UNION" operator in the view's definition (if I use "ordinary" view - witchout a "UNION" operator, then both of the queries work fine)

Does anybody know anything in the subject? All suggestions welcomed

Please vrite on my priva e-mail

---

Mateusz Klos
System Developer

IFS Poland Sp. z o.o.
80-241 Gdańsk
ul. Grunwaldzka 46
tel. +(48 58) 345 29 64 - 66
fax. +(48 58) 345 29 67
email:M.Klos_at_ifs.com.pl

---

Received on Fri Mar 12 1999 - 06:56:33 CST