OracleClient stored procedure parameter - can it handle 8 bit VarChars?

From: Brad Bennett (bfbenn_at_earthlink.net)
Date: 06/01/04 

Date: Tue, 1 Jun 2004 13:05:07 -0500

I'm trying to execute a pair of Oracle stored procedures that
encrypt/decrypt a character string using Oracle's obfuscation package. Each
stored procedure has an input and an output parameter. One procedure
encrypts a string, the other decrypts a string.

The problem is that when I encrypt a value the procedure executes without
incident, but the return string is losing it's high-order bits. What I get
back is a value that looks encrypted, but when I feed the string to the
decryption procedure I don't get my original value back. When we compare
the string returned by my .Net function to the string returned when
executing the sp under SQL*Plus we see that several characters are 80h
"smaller" in the .Net functional return than they are when the sp is
executed under SQL*Plus.

The database is Oracle 9i, running with an eight bit character set, but I
don't see any property in the .Net OracleClient that allows me to specify
that I expect 8 bit characters back from Oracle.

Can anyone shed any light on this for me?
How can I get .Net to understand that Oracle is returning 8 bit characters?

Thanks much,
Brad

Relevant Pages

  • OracleType.NVarChar parameters handled differently in framework 1.1?
    ... A 2001 character string parameter, consisting entirely of 7 bit characters, ... sent to a 9.2.0.1 stored procedure works under the optional 1.0 Oracle ... IDataParameter interface is now only 2000 characters, ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Oracle NULL vs revisited
    ... On Aug 17, 2:44 pm, "David Portas" ... string values supported by Oracle is not equivalent to the domain of string ... anywhere except Oracle. ... I don't agree that a string consisting of zero characters IS a value. ...
    (comp.databases.oracle.server)
  • Re: Oracle NULL vs revisited
    ... string values supported by Oracle is not equivalent to the domain of ... anywhere except Oracle. ... I don't agree that a string consisting of zero characters IS a value. ... Only if "" carries some meaning. ...
    (comp.databases.oracle.server)
  • Question about Oracle JDBC setFormOfUse for storing NLS data
    ... I am doing this because, Oracle, in the JDBC Application Developer's ... if you bind or define a Java string for a column of SQL ... What is happening is that till a Java String of 2000 characters, ...
    (comp.databases.oracle.misc)
  • Re: Prothon should not borrow Python strings!
    ... """It does not make sense to have a string without knowing what encoding ... same cul de sac as Python. ... Prothon_String_As_ASCII // raises error if there are high characters ... Python's split between byte strings and Unicode strings is ...
    (comp.lang.python)