>- see footer for list info -< What are the arguments you're sending to this SP? This sure has something to do with not enough arguments being passed to it (assuming the Sp is ok).
Cheers On 04/11/2008, mohd shaffiq mohd yusof <[EMAIL PROTECTED]> wrote: > > >- 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 -< > -- Marcos Placoná www.placona.co.uk _______________________________________________ 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 -<
