Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.tools -> Strange Oracle 8 ORA-01002

Strange Oracle 8 ORA-01002

From: <ruku_at_my-deja.com>
Date: 2000/01/28
Message-ID: <86sv0d$ntd$1@nnrp1.deja.com>#1/1

Hi everybody,

I have a simple sql query with outer joins works fine when tested in Oracle 8 server from a sql 7.3 client. But the same query when tested on the same Oracle 8 database from a Oracle8 client it gives me

ERROR- 01002 Fetch out of sequence.

Could anybody help me to figure out what's happening here. Attached is the sql script

thanks
Rukmini

SELECT
    SERVICE_REQUEST.ID,
    DESC_TEXT.BIG_TEXT,
    DESC_TEXT2.BIG_TEXT
FROM

    rmoc63.SERVICE_REQUEST,
    rmoc63.UTILITY,
    rmoc63.ACTIVITY,
    rmoc63.STREET,
    rmoc63.STREET xSTREET,
    rmoc63.STREET mSTREET,
    rmoc63.DESC_TEXT DESC_TEXT,
    rmoc63.DESC_TEXT DESC_TEXT2

WHERE
    SERVICE_REQUEST.UTILITYID = UTILITY.CODE (+) AND
    SERVICE_REQUEST.WORKDESCID = ACTIVITY.CODE (+) AND
    SERVICE_REQUEST.STREETID = STREET.ID (+) AND
    SERVICE_REQUEST.XSTREETID = xSTREET.ID (+) AND
    SERVICE_REQUEST.MAILSTREET = mSTREET.ID (+) AND
    SERVICE_REQUEST.ID = DESC_TEXT.P_ID (+) AND
    SERVICE_REQUEST.ID = DESC_TEXT2.P_ID (+) AND
    SERVICE_REQUEST.ID = 2046729 AND
    DESC_TEXT2.TABLE_NAME(+) = 'SERVICE_REQUEST' AND
    DESC_TEXT2.FLD_NAME(+) = 'LOCDESC' AND
    DESC_TEXT.TABLE_NAME(+) = 'SERVICE_REQUEST' AND     DESC_TEXT.fLD_NAME(+) = 'REQUESTTEXT'

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Fri Jan 28 2000 - 00:00:00 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US