No subject


Fri Feb 8 08:55:55 EST 2008


We are anxious about how soon it’s going to be, because our project depends on it.
 
The following code successfully ran under Microsoft .NET framework but
caused error under Mono "ORA-01036: illegal variable name/number".
 
Thank you in advance!
 
CODE:

     OracleCommand command = new OracleCommand( "PKG_AUTH_DEV.ip_authentic2", m_dbConnection );
     command.CommandType = CommandType.StoredProcedure;

     command.Parameters.Add( "p_login", OracleType.Char, 20 );
     command.Parameters[ "p_login" ].Value = "name";
     command.Parameters[ "p_login" ].Direction = ParameterDirection.Input;

     command.Parameters.Add( "p_password", OracleType.Char, 20 );
     command.Parameters[ "p_password" ].Value = "pass";
     command.Parameters[ "p_password" ].Direction = ParameterDirection.Input;

     command.Parameters.Add( "p_xml_config", OracleType.Clob );
     command.Parameters[ "p_xml_config" ].Direction = ParameterDirection.Output;

     command.ExecuteNonQuery();

Friday, May 14, 2004, 3:05:16 PM, you wrote:

JR> Hello Sergey,

>> -----Original Message-----
>> From: mono-devel-list-admin at lists.ximian.com 
>> [mailto:mono-devel-list-admin at lists.ximian.com] On Behalf Of 
>> Spatar Sergey
>> Sent: Friday, May 14, 2004 12:17 PM
>> 
>>   I'm interesting about when stored procedures and large objects
>>   (blob, clob) support will be included in System.Data.OracleClient.
>> 

JR> What are you missing? We are working with large objects
JR> for some time now.

JR> Joerg.

-- 
Best regards,
Sergey Spatar





More information about the Mono-devel-list mailing list