Re: oracle 9 insert query

From: Tom Best <tom.best_at_bentley.com>
Date: Tue, 25 May 2004 10:33:05 -0400
Message-ID: <c8vkc6$cg2$1@news.bentley.com>

It seems that when the query is run locally, it doesn't work. When it is run remotely, it does. Since you have a select against a local table, it runs locally by default.

Try this, and see if it works:

insert /*+ driving_site(a) */ into BGCI_TIMEOUT_at_LNK14.WORLD a SELECT * FROM BGCI_TIMEOUT Tom Best

"pat saunders" <pat.saunders_at_sis.securicor.co.uk> wrote in message news:bc0e3bd8.0405250627.4e631420_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 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:33:05 CDT