Oracle Stored Proces

[Joe Chandler]

What am I missing?   Trying to execute a very simple stored procedure for a proof of concept with Oracle… (I am using MS provider for oracle.) I am getting the following error: Message: ORA-06550: line 1, column 7: PLS-00306: wrong number or types of arguments in call to 'RAISE_IT' ORA-06550: line 1, column 7: PL/SQL: Statement ignored  System.Data.OracleClient.OracleException: ORA-06550: line 1, column 7: PLS-00306: wrong number or types of arguments in call to 'RAISE_IT' ORA-06550: line 1, column 7: PL/SQL: Statement ignored           The proc looks like this: CREATE OR REPLACE PROCEDURE RAISE_IT (REQUEST_ID IN VARCHAR) IS BEGIN       INSERT INTO PRJ_STATUS_LUT(CODE, DISPLAY_NAME, SORT_ORDER) VALUES('IN_PLANNING', 'In Planning', 0); EXCEPTION    WHEN OTHERS THEN        RAISE_APPLICATION_ERROR(-20500,REQUEST_ID); END; /     The SQL Map has the following inside it: <parameterMaps>               <parameterMap id="copyRequestDetails-params">                      <parameter property="Id" column="REQUEST_ID" dbType="VARCHAR"/>               </parameterMap> </parameterMaps>     <procedure id="copyRequestDetails" parameterMap="copyRequestDetails-params"> raise_it </procedure>     The C# code is written as follows: IDataManager mgr = DataManagerFactory.GetInstance("ScenarioDataManager"); Hashtable hash = new Hashtable(); hash.Add("Id","SOME TEST DATA"); mapper.Update(“copyRequestDetails”,hash);     The error I am getting is as follows:     SQL for statement 'copyRequestDetails' :raise_it 2005-04-07 14:08:46,605 [2612] ERROR TestCases.StoredProcedureTC - Exception: Autodesk.Consulting.Common.DataManagers.DataManagerException Message: ORA-06550: line 1, column 7: PLS-00306: wrong number or types of arguments in call to 'RAISE_IT' ORA-06550: line 1, column 7: PL/SQL: Statement ignored  System.Data.OracleClient.OracleException: ORA-06550: line 1, column 7: PLS-00306: wrong number or types of arguments in call to 'RAISE_IT' ORA-06550: line 1, column 7: PL/SQL: Statement ignored      at System.Data.OracleClient.OracleConnection.CheckError(OciErrorHandle errorHandle, Int32 rc)     Joe Chandler Technical Consultant   Autodesk, Inc. 7935 East Prentice Ave.,  Suite 104 Greenwood Village, CO 80111   Direct       303 256-5903 Mobile      303 960-5536 Fax          303 256-5950

<<image001.gif>>