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 -> Re: oracle 9.0 pl/sql query

Re: oracle 9.0 pl/sql query

From: Erik Ykema <ErikFOO_at_ykema.ws>
Date: Fri, 11 Jun 2004 23:02:05 +0200
Message-ID: <40ca1dd7$0$6795$e4fe514c@news.xs4all.nl>


"pat saunders" <pat.saunders_at_sis.securicor.co.uk> wrote in message news:bc0e3bd8.0405250630.7832528d_at_posting.google.com...
> Hi,
> I am attempting to use Oracle PL/SQL queries from an Oracle 7.3.4 DB
> running under Windows NT (BOX A) to update an Oracle 7.3.4 DB running
> under solaris 2.6 (BOX B) over TCP / IP links. These standard queries
> worked fine.
> Recently we upgraded BOX B to Oracle 9.2 running under Solaris 8.0.
> When on BOX A , I run the sql command :
> insert into BGCI_TIMEOUT_at_LNK14.WORLD SELECT * FROM BGCI_TIMEOUT ,
> I get the floowing errors :
> ORA-01003 : No statement parsed
> ORA-02063: PRECEDING LINE FROM LNK14
>
> If I run the SQL query : insert into BGCI_TIMEOUT_at_LNK14.WORLD
> VALUES('GPRS','TEST','50') , it works fine.
> With both queries I delete the contents of DB table BGCI_TIMEOUT
> first.
> I am puzzled why the first query fails.
> Any help appreciated.
> Ta
> Pat

You might want to look into:
http://groups.google.com/groups?q=ORA-02063+group:comp.databases.oracle.*&hl=en&lr=&ie=UTF-8&group=comp.databases.oracle.*&scoring=d&selm=2hjkfcFdro87U1%40uni-berlin.de&rnum=1 but you could have found that out yourselve too, perhaps. Good luck,
Erik Ykema Received on Fri Jun 11 2004 - 16:02:05 CDT

Original text of this message

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