[Mono-list] Problem with datetime format and oracle...

Daniel Morgan danielmorgan@verizon.net
Sun, 20 Feb 2005 06:55:44 -0500


I have checked into svn (Mono's subversion repository) some fixes for 
OracleDateTime and DBNull.Value when using input parameters.   This was 
accomplished by getting the NLS_DATE_FORMAT for the session from the 
Oracle server via the OCINlsGetInfo function.

More fixes need to be done, such as, support for using BLOBs and CLOBs 
as input parameters and other data types.  Need fixes for output, 
return, and ref parameters.

Kelly Leahy wrote:

>--- Daniel Morgan <danielmorgan@verizon.net> wrote:
>
>  
>
>>The Oracle dictionary view NLS_SESSION_PARAMETERS is
>>helpful too.  I 
>>know this available on Oracle 9i, but I don't know
>>if it's available on 
>>Oracle 8i.  Oracle 8i docs are not available on OTN
>>because its not 
>>supported by Oracle anymore.
>>    
>>
>
>I believe NLS_SESSION_PARAMETERS is available as far
>back as 7.3, but I'm sure its at least available in 8i
>(of course if the permissions are ok for you to view
>it).
>
>Kelly
>
>_______________________________________________
>Mono-list maillist  -  Mono-list@lists.ximian.com
>http://lists.ximian.com/mailman/listinfo/mono-list
>
>  
>