>- see footer for list info -< Hi All, Need your advise regarding this prob :-
ORA-06550: line 1, column 7: PLS-00306: wrong number or types of arguments in call to 'PROJECT_SUM_STRATEGY_PROC' ORA-06550: line 1, column 7: PL/SQL: Statement ignored My SP :- create or replace PROCEDURE "PROJECT_SUM_STRATEGY_PROC" (P_PRJ_VERSION_ID IN NUMBER, P_PRJ_ID IN NUMBER, OUT_CUR OUT PKG_COMMON.CURCOMMON) IS BEGIN OPEN OUT_CUR FOR SELECT option_id, option_description,insurance_cost_rec_percent, government_cost_rec_percent,DOCUMENT_REC_INFO, option_short_name, probability_of_occurance,decile_selected_ind, option_selection_rationale, currency_id, option_number_selected, option_budget_aggregate_total,probability_of_occur ance, NVL((SELECT no_of_years-DECODE(TO_CHAR(p.current_budget_year,'YYYY') + TO_NUMBER(TO_CHAR(MIN(wbs_budget_date), 'YYYY')),NULL, 0, TO_CHAR(p.current_budget_year,'YYYY') - TO_NUMBER(TO_CHAR(MIN(wbs_budget_date), 'YYYY'))) no_of_years FROM wbs_budget_amt WHERE option_id = options.option_id AND prj_version_id = P_PRJ_VERSION_ID AND prj_master_id = project_master.prj_master_id),0) no_of_years1, NVL((SELECT TO_NUMBER(TO_CHAR(MAX(wbs_budget_date),'YYYY')) -TO_NUMBER(TO_CHAR(MIN(wbs_budget_date),'YYYY'))+1 FROM wbs_budget_amt , portfolio WHERE option_id = options.option_id AND prj_version_id = P_PRJ_VERSION_ID AND prj_master_id = project_master.prj_master_id AND WBS_BUDGET_DATE >= CURRENT_BUDGET_YEAR),0) no_of_years FROM project_version, project_master, options, portfolio p where p.portfolio_name = 'TRW' AND project_version.prj_master_id = project_master.prj_master_id AND project_version.prj_master_id = options.prj_master_id AND project_version.prj_version_id = options.prj_version_id AND options.active_ind='Y' AND project_master.prj_master_id = P_PRJ_ID AND project_version.prj_version_id = P_PRJ_VERSION_ID ORDER BY options.probability_of_occurance DESC,option_short_name; END PROJECT_SUM_STRATEGY_PROC; I do ask forum but some one ask me to create a cursor and provide bind variable for parameter OUT_CUR OUT PKG_COMMON.CURCOMMON. Any idea? Because I'm not sure to create a cursor and provide bind varable for that parameter. Regards, Shaffiq _______________________________________________ For details on ALL mailing lists and for joining or leaving lists, go to http://list.cfdeveloper.co.uk/mailman/listinfo -- CFDeveloper Sponsors:- >- cfdeveloper Hosting provided by www.cfmxhosting.co.uk -< >- Lists hosted by www.Gradwell.com -< >- CFdeveloper is run by Russ Michaels, feel free to volunteer your help -<
