Oracle Database Discussions

We are executing the following query from a JSP Page using JDBC, which results in Exception

java.sql.SQLException: ORA-21710: argument is expecting a valid memory addr
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:331)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:288)
at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:745)
at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:216)



SELECT a.class_code classcodeid ,
b.class_code classcodename ,
a.scenario sceid ,
c.name scename ,
a.planning_cycle pcid ,
NVL(ROUND((a.funds_available / d.pc_display_factor), 1), 0) fundsavail,
NVL(ROUND((a.funds_required / d.pc_display_factor), 1), 0) fundsreq ,
NVL(ROUND((a.funding_variance / d.pc_display_factor), 1), 0) fundsvar ,
NVL(ROUND((e.funds_available / d.pc_display_factor), 1), 0) scefunds ,
NVL(ROUND(a.funds_required / e.funds_available * 100, 0), 0) fundspct
FROM fpa_aw_pclass_funds_v a ,
pa_class_codes b ,
fpa_sces_vl c ,
fpa_aw_pc_disc_funds_v d,
fpa_aw_sce_funds_v e
WHERE a.class_code = b.class_code_id
AND a.scenario = c.scenario
AND a.scenario = e.scenario
AND a.planning_cycle = d.planning_cycle
AND a.scenario = 10040
UNION
SELECT a.class_code classcodeid ,
c.class_code classcodename ,
b.scenario sceid ,
d.name scename ,
a.planning_cycle pcid ,
NVL(ROUND(((a.investment_mix / 100) *(b.funds_available / e.pc_display_factor)), 1), 0) fundsavailable,
0 fundsreq ,
NVL(ROUND(0 -((a.investment_mix / 100) *(b.funds_available / e.pc_display_factor)), 1), 0) fundsvar ,
NVL(ROUND((b.funds_available / e.pc_display_factor), 1), 0) scefunds ,
0 fundspct
FROM fpa_aw_pc_inv_matrices_v a,
fpa_aw_sce_funds_v b ,
pa_class_codes c ,
fpa_sces_vl d ,
fpa_aw_pc_disc_funds_v e
WHERE a.class_code = c.class_code_id
AND b.scenario = d.scenario
AND a.planning_cycle = e.planning_cycle
AND a.planning_cycle = b.planning_cycle
AND b.scenario = 10040
AND a.class_code NOT IN
(SELECT class_code
FROM fpa_aw_pclass_funds_v
WHERE scenario = 10040
)

This query uses OLAP_TABLE function and after reviewing the error documentation , its not clear which object memory address which we pass is incorrect.

Kindly advises , if there is any pointer to diagnose this issue further. Alert log does not show any exception

Thanks

Joseph George