ORA-01460: unimplemented or unreasonable conversion requested
I am getting the following error when trying to create a report in BIDS 2008: ORA-01460: unimplemented or unreasonable conversion requested I am calling a stored proecdure in my report, the precodure runs fine on toad and it even runs fine on the query builder in BIDS, but when i execute my report, i get the above error. i have even tried to comment out the date and number fields from my procedure, but no change. the maximum size of the datatype in my procedure is 4000, and that too for only one variable. below is the code of the procedure i am calling. i am stuck.. please help. /* Formatted on 10/18/2012 1:11:19 PM (QP5 v5.215.12089.38647) */ CREATE OR REPLACE PROCEDURE KPI_HORIZON.Get_Monthly_Data_1 ( result IN KPI_HORIZON.KPI_SUMMARY_REPORTING.KPIRESULT%TYPE, kpigroup IN KPI_HORIZON.KPI_SUMMARY_REPORTING.KPIGROUP%TYPE, regulatory IN KPI_HORIZON.KPI_SUMMARY_REPORTING.REGULATORY%TYPE, crispy IN KPI_HORIZON.KPI_SUMMARY_REPORTING.CRISPY%TYPE, mainarea IN KPI_HORIZON.KPI_SUMMARY_REPORTING.MAINAREA%TYPE, subarea IN KPI_HORIZON.KPI_SUMMARY_REPORTING.SUBAREA%TYPE, pi IN KPI_HORIZON.KPI_SUMMARY_REPORTING.KPIHEADER%TYPE, kpictgry IN KPI_HORIZON.KPI_SUMMARY_REPORTING.KPICTGRY%TYPE, test_cursor OUT SYS_REFCURSOR) IS BEGIN IF (mainarea = 'ALL') THEN OPEN test_cursor FOR SELECT DISTINCT -- TO_CHAR ( (kpiid)) kpiid, kpigroup, kpictgry, kpiheader, headerdescription, crispy, regulatory, -- TO_CHAR (previousquantity) previousquantity , -- TO_CHAR (TO_DATE (previousdate, 'DD/MM/YYYY')) previousdate, -- TO_CHAR (actualquantity) actualquantity, kpioperator, -- TO_CHAR (TO_DATE (actualdate, 'DD/MM/YYYY')) actualdate, kpiresult, kpicolor, -- TO_CHAR (q1) q1, -- TO_CHAR (q2) q2, vf, unitofmeasurement, subarea, mainarea, kpifrequency, comments, active_ind FROM kpi_summary_reporting WHERE kpifrequency = 'Monthly' AND kpiresult IN (result) AND kpigroup IN (kpigroup) AND regulatory IN (regulatory) AND crispy IN (crispy) AND kpiheader IN (pi) AND KPICTGRY IN (kpictgry) AND active_ind = 'Y'; ELSE OPEN test_cursor FOR SELECT DISTINCT -- TO_CHAR ( (kpiid)) kpiid, kpigroup, kpictgry, kpiheader, headerdescription, crispy, regulatory, -- TO_CHAR (previousquantity) previousquantity , -- TO_CHAR (TO_DATE (previousdate, 'DD/MM/YYYY')) previousdate, -- TO_CHAR (actualquantity) actualquantity, kpioperator, -- TO_CHAR (TO_DATE (actualdate, 'DD/MM/YYYY')) actualdate, kpiresult, kpicolor, -- TO_CHAR (q1) q1, -- TO_CHAR (q2) q2, vf, unitofmeasurement, subarea, mainarea, kpifrequency, comments, active_ind FROM kpi_summary_reporting WHERE kpifrequency = 'Monthly' AND kpiresult IN (result) AND kpigroup IN (kpigroup) AND regulatory IN (regulatory) AND crispy IN (crispy) AND mainarea IN (mainarea) AND subarea IN (subarea) AND kpiheader IN (pi) AND KPICTGRY IN (kpictgry) AND active_ind = 'Y'; END IF; END;
October 18th, 2012 3:48pm

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics