[Mono-bugs] [Bug 565149] New: ORACLE StoredProcedure with OracleParameter type NUMBER OutPut throw ORA-06502

[bugzilla_noreply at novell.com]

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: bnc-blr-team-mono at forge.provo.novell.com
        ReportedBy: dlahaye at gmail.com
         QAContact: mono-bugs at lists.ximian.com
          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.