SQR 3 vs. SQR 4.3.4

["Stuck, Crystal" <Crystal.Stuck@PS.NET>]

We are operating on Sun Solaris 2.5.1, Oracle 8.0.4.4.0, SQR 4.3.4,
PeopleSoft version 7.01, and PeopleTools version 7.05.10.  We just upgraded
our tools suite which included the upgrade from SQR3 to SQR 4.3.4.  In doing
this we have a customized program that errors out in SQR 4.3.4 but runs fine
in SQR 3.  We are receiving the following error:

(SQR 5528) ORACLE OFEN error 600 in cursor 10:
   ORA-00600: internal error code, arguments: [12403], [], [], [], [], [],
[], []

Error on line 573:
   (SQR 3725) Bad return fetching row from database.

SQR: Program Aborting.

We called ORACLE and they said this is a bug when using Hash Joins across
systems.  We access tables on another ORACLE system.  The tables are created
as views on the other system and we create synonyms to the views on our
system.  According to ORACLE, to correct the problem, set the 'ALTER SESSION
SET HASH_JOIN_ENABLED = FALSE'.  We tried this but got the same error
message.  We have tried creating a view of the specific joins on the other
system and access the view.  This works on a small test program but still
blows up on the program in question.  We tried to embed ORACLE hints in the
SQR but these also did not appear to work.  We included the hint on the view
on the other system.  This worked for the test system but not the original
program.

Our original logic had DECODE statements from two different tables on the
other system.  We rewrote the code to pull the two fields and do the logic
inside the SQL statement instead.  This apparently worked for the SQL in
question but now I am getting the same error on another SQL statement later
in the program, that is not using DECODE statements.

First SQL statement:
Begin-Select
C.Cust_Code                     &bk_cust_id
A.Promised_Quantity &bk_prom_qty
C.Metric_Ind            &bk_metric_ind
!decode(C.Metric_Ind,'Y',A.Promised_Quantity*2.20460002,NULL) &bk_qty_m
!decode(C.Metric_Ind,'N',A.Promised_Quantity,NULL)
&bk_qty_e
D.New_Value                     &bk_product
RSC_Psoft.ProdCodeSubCat(D.New_Value) &bk_cat
...
>From COM_Cust_Promise_Date A, COM_Mill_Order B, COM_Cust_Order C,
RSC_GL_Xlat_Tbl D
Where A.Mill_Order = B.Mill_Order
        and A.Mill_Order = C.Mill_Order
        and B.Bill_As_Code = D.Old_Value
        and D.Type = 'BILL AS'
        and A.Promised_Date between To_Date($month-begin,'YYYY-MM-DD') and
To_Date($month-end,'YYYY-MM-DD')
End-Select

The COM... tables are from the other system. The RSC... table is from my
system.  This shows where I commented out the DECODE statements and selected
the fields from the tables.  This seems to have corrected the problem with
this one.

Second SQL statement:
Begin-Select
C.Cust_Code                     &ioh_cust_id
A.Weight_Yielded        &ioh_qty
D.New_Value                     &ioh_product
RSC_Psoft.ProdCodeSubCat(D.New_Value) &ioh_cat
 ...
>From COM_Inventory A, COM_Mill_Order B, COM_Cust_Order C, RSC_GL_Xlat_Tbl D,
        COM_Inventory_Hold2 E
Where A.Mill_Order = B.Mill_Order
        and A.Mill_Order = C.Mill_Order
        and A.Location in ('2','3')
        and A.Status_Cond_Code = '1005'
        and A.Tag_ID = E.Tag_ID
        and E.Hold_Code not in ('004','006','007')
        and B.Bill_As_Code = D.Old_Value
End-Select

This is the second statement that is in error.  The COM... tables are from
the other system.  The RSC.. tables are from my system.  As you can see
there are NO DECODE statements.

My main question is why does this work in SQR3 and not SQR 4.3.4.  The only
way we can run this report is to run from SQR3 and this is not an acceptable
solution.

ANY help would be greatly appreciated.

Thank you..

Crystal Stuck
perotsystems
(313) 317-6778