| ORA-00600 [message #63195] |
Thu, 16 September 2004 12:27 |
Jadie
Messages: 64
Registered: January 2002
|
Member |
|
|
Can anyone look at my trace file below and tell me why this query can cause the 00600 error? Appreciate any response!
ORA-00600: internal error code, arguments: [[qcplgnt : no null terminator]], [[]], [[]], [[]], [[]], [[]], [[]], [[]]
Current SQL statement for this session:
SELECT
ebp.transaction_date "Date",
ebp.consumer_acct_id "Account",
count(ebp.ebp_trans_id) "# of refill",
sum(ebp.ebp_amount) "Amount",
fee1.debt_amount - nvl(fee2.credit_amount,:"SYS_B_00") "Fee Paid",
:"SYS_B_01" "RPM"
FROM
ebp_transactions ebp
left outer join
(select trans_date, consumer_acct_id, sum(debt_amount) debt_amount
from ca_transactions
where to_char(trans_date,:"SYS_B_02") = to_char(sysdate-:"SYS_B_03",:"SYS_B_04")
and trans_type_id = :"SYS_B_05" and credit_amount = :"SYS_B_06"
group by trans_date, consumer_acct_id) fee1 on
(fee1.consumer_acct_id = ebp.consumer_acct_id
and trunc(trans_date) = trunc(ebp.transaction_date))
left outer join
(select trans_date, consumer_acct_id, sum(credit_amount) credit_amount
from ca_transactions
where to_char(trans_date,:"SYS_B_07") = to_char(sysdate-:"SYS_B_08",:"SYS_B_09")
and trans_type_id = :"SYS_B_10" and debt_amount = :"SYS_B_11"
group by trans_date, consumer_acct_id) fee2 on
(fee2.consumer_acct_id = ebp.consumer_acct_id
and trunc(trans_date) = trunc(ebp.transaction_date))
where to_char(ebp.transaction_date,:"SYS_B_12") = :"SYS_B_13"
and status = :"SYS_B_14"
group by transaction_date, consumer_acct_id
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
