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 following 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
Received on Tue May 25 2004 - 09:28:53 CDT
