Re: oracle 9 PL/SQL query

On 25 May 2004 07:28:53 -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 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

No need to be puzzled. Oracle 7.3.4 was supplanted by Oracle 8.0 in 1998, so in the stone age. Officially connections from a 7.3.4 database to a 9i database are not supported and not certified. Also the communication technology changed in 8.0. Consequently you shouldn't be surprised when it doesn't work.

--
Sybrand Bakker, Senior Oracle DBA