Ta,
Sorry what do you mean by /*+ driving_site(a) ??
Cheers,
Pat
"Tom Best" <tom.best_at_bentley.com> wrote in message news:<c8vkc6$cg2$1_at_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 Wed May 26 2004 - 05:26:37 CDT
