[Mono-bugs] [Bug 535889] New: Unable to access output parameter of stored procedure

bugzilla_noreply at novell.com bugzilla_noreply at novell.com
Tue Sep 1 06:01:28 EDT 2009


           Summary: Unable to access output parameter of stored procedure
    Classification: Mono
           Product: Mono: Class Libraries
           Version: 2.4.x
          Platform: Other
        OS/Version: RHEL 4
            Status: NEW
          Severity: Major
          Priority: P5 - None
         Component: Sys.Data
        AssignedTo: bnc-blr-team-mono at forge.provo.novell.com
        ReportedBy: suguna6309 at gmail.com
         QAContact: mono-bugs at lists.ximian.com
          Found By: ---

User-Agent:       Mozilla/4.0 (compatible; MSIE 7.0; Windows NT 5.1; GTB6; .NET
CLR 2.0.50727)

I m working on Oracle DB with stored procedures. In SP, I have one input param
and two output params. 
lUserStatus                IN OUT  NUMBER,
loggedinIP                 IN OUT  VARCHAR2

tParams(2, 0) = "@loggedinIP" 
tParams(2, 1) should return the value. But it shows blank.
I m unable to access VARCHAR2 type out variable in my component from Mono. 
Can some one pl. help me..Thanx..

Reproducible: Always

Steps to Reproduce:
1.Create an sp with one string and one number type output params
2.on a sample function of a component, try to access like this : tParams(2, 1)
3. It shows blank. If I access using dataset, i m able to access string data
type also.
Actual Results:  
Output param returns empty value

Expected Results:  
It should return the string value like something like this..

Configure bugmail: http://bugzilla.novell.com/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the QA contact for the bug.

More information about the mono-bugs mailing list