Compilation Error in Sqr V6.0

[Ezhil Balasubramanian <ezhilb@HOTMAIL.COM>]

Hi,
  I am new to SQR and this is the first time I am posting a question.
We are working in Oracle 8.0.5 and the SQR veersion is V6.0
When i compile a specific program , i am getting a series of this error,
whereas the same program when i compiled in Oracle 7.3.4 and sqr version is
4.0.2

this is the program compilation error, when i tried to compile and run in
the command line in HP Unix

$sqr PINV0025
Enter Username: apps
Enter Password:

SQR V6.0
Copyright (C) Brio Technology 1994-2000.  All Worldwide Rights Reserved.

(SQR 5528) ORACLE OPARSE error -942 in cursor 1:
   ORA-00942: table or view does not exist
SQL:  SELECT distinct TO_CHAR(sysdate,'DD-MON-YY HH24:MI'),
      TO_CHAR(sysdate,'DD-MON-YY')  FROM system.dual
Error at:  dual

Error on line 130:
   (SQR 3716) Error in SQL statement.

(SQR 5528) ORACLE OPARSE error -942 in cursor 3:
   ORA-00942: table or view does not exist
SQL:  SELECT distinct upper(rtrim(:1,' ')), upper(rtrim(:2,' ')),
      upper(rtrim(:3,' ')), upper(rtrim(:4,' ')), upper(rtrim(:1,' ')  ||
      '%'), upper(rtrim(:2,' ') || '%')  from system.dual
Error at:  dual

Error on line 178:
   (SQR 3716) Error in SQL statement.

(SQR 5528) ORACLE OPARSE error -942 in cursor 13:
   ORA-00942: table or view does not exist
SQL:  SELECT distinct round(:1/:2, 0)  from system.dual
Error at:  dual

Error on line 744:
   (SQR 3716) Error in SQL statement.


Errors were found in the program file.

SQR: Program Aborting.


The same program compiled successfully in the oracle 7.3.x and sqr v4.0.2
environment :

$sqr PINV0025
Enter Username: apps
Enter Password:

SQR V4.0.2
Copyright (C) SQRIBE Technologies, 1994-97.  All Worldwide Rights Reserved.

Enter Organization : :



Thanks in Advance for help

Ezhil



_________________________________________________________________________
Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com.

Share information about yourself, create your own public profile at
http://profiles.msn.com.