oracle 9.0 pl/sql query
From: pat saunders <pat.saunders_at_sis.securicor.co.uk>
Date: 25 May 2004 07:30:16 -0700
Message-ID: <bc0e3bd8.0405250630.7832528d_at_posting.google.com>
Hi,
[Quoted] 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 Received on Tue May 25 2004 - 16:30:16 CEST
Date: 25 May 2004 07:30:16 -0700
Message-ID: <bc0e3bd8.0405250630.7832528d_at_posting.google.com>
Hi,
[Quoted] 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 Received on Tue May 25 2004 - 16:30:16 CEST