http://bugzilla.novell.com/show_bug.cgi?id=565149
http://bugzilla.novell.com/show_bug.cgi?id=565149#c0 Summary: ORACLE StoredProcedure with OracleParameter type NUMBER OutPut throw ORA-06502 Classification: Mono Product: Mono: Class Libraries Version: 2.4.x Platform: x86 OS/Version: SLES 11 Status: NEW Severity: Normal Priority: P5 - None Component: Sys.Data AssignedTo: [email protected] ReportedBy: [email protected] QAContact: [email protected] Found By: --- Blocker: --- User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.1; fr; rv:1.9.1.6) Gecko/20091201 Firefox/3.5.6 (.NET CLR 3.5.30729) Since version 2.4.3, when i call a StoredProcedure with an OracleParameter type NUMBER with direction set to OUTPUT, this error is throwed : ORA-06502: PL/SQL: numeric or value error: character string buffer too small Reproducible: Always Steps to Reproduce: 1. create StoredProcedure with one parameter ( P_NUM out NUMBER), set a value to the parameter in the StoredProcedure (5 for example). PROCEDURE Test2(P_NUM out NUMBER) IS BEGIN P_NUM := 5; END; 2. call this StoredProcedure with an OracleParameter direction set to OUTPUT and type NUMBER. OracleParameter param1 = cmd.CreateParameter(); param1.ParameterName = "P_NUM"; param1.OracleType = OracleType.Number; param1.Direction = ParameterDirection.Output; param1.Value = 1; param1.Size = 2; 3. you can use the test class "OutParmTest2" located at this url (2.4.3 sources) http://anonsvn.mono-project.com/source/branches/mono-2-4-3/mcs/class/System.Data.OracleClient/Test/TestOracleClient.cs it failed with the same error. Actual Results: ORA-06502: PL/SQL: numeric or value error: character string buffer too small Expected Results: the result is the value set in the storedProcedure, 5 in my example -- Configure bugmail: http://bugzilla.novell.com/userprefs.cgi?tab=email ------- You are receiving this mail because: ------- You are the QA contact for the bug. _______________________________________________ mono-bugs maillist - [email protected] http://lists.ximian.com/mailman/listinfo/mono-bugs
