Re: Data encryption

Laurent,

>1/
>I'd like to know if Oracle provided Algorythms to encrypt data, like
>functions I could use with
>stored procedure, in PL/SQL block....
>

Have a look at the DBMS_OBFUSCATION_TOOLKIT, it provides DES encryption (Oracle 8i)

>You know, with Interbase I used to encrypt some of my data with Delphi, then
>insert them into Interbase...but my functions under Delphi don't work
>anymore when inserting into Oracle.
>

 I don't know what interbase uses, but I suspect it's not PL/SQL, you'll probably have to rewrite them.
 From a Delphi background, you might find that writing your stored procedures in Java may be easier than PL/SQL (only as of Oracle 8i though I believe)

>2/
>With Interbase, I'm using the following types : SmallInt and Integer.
>I'd like to know how would these types be under Oracle...I have converted
>them into Number(5) and
>Number(10)...but I'm not sure it's a good conversion...
>I think the types "SmallInt" and "Integer" exist under Oracle...but do they
>exist under Oracle 7, 8, 9 and futur versions ????
>

Have a look in the Server reference to find a match for your old datatypes.

SMALLINT and INTEGER are not likely to change, if they match your Interbase sizes, you can rely on them (make sure their byte sizes are the same though)

Hope that helps

Brice Received on Wed Nov 28 2001 - 05:57:09 CST