Re: oracle 9.0 pl/sql query

From: Sybrand Bakker <gooiditweg_at_nospam.demon.nl>
Date: Tue, 25 May 2004 19:59:45 +0200
Message-ID: <9b27b01vehbjmb97515q1ofic372i3l0hq_at_4ax.com>


On 25 May 2004 07:30:16 -0700, pat.saunders_at_sis.securicor.co.uk (pat saunders) wrote:

>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

Please do not cross and multipost. You're wasting people's bandwith and time

--
Sybrand Bakker, Senior Oracle DBA
Received on Tue May 25 2004 - 19:59:45 CEST

Original text of this message