when i run the plsql block for the encryption i got this error, pls tell what to do ERROR at line 7: ORA-06550: line 7, column 1: PLS-00201: identifier 'DBMS_OBFUSCATION_TOOLKIT.DESENCRYPT' must be declared thanks Vadim Gorbounov wrote: > Sorry, important add-in, > this should work too > > dbms_obfuscation_toolkit.DESencrypt( > input_string => data, > key_string => key, > encrypted_string => ddata); > Vadim > > -----Original Message----- > Sent: Wednesday, March 21, 2001 4:30 PM > To: Multiple recipients of list ORACLE-L > > help! I am by no means the world's best PL/SQL programmer (heck, I can > barely program in it, PL/SQL 101 is on my desk at home) > > I am trying to see how hard it would be to add encryption to sensitive data > in our database, so I'm playing with DBMS_OBFUSCATION_TOOLKIT. > > I created a table: > SQL> desc test_encrypt > Name Null? Type > ------------------------------- -------- ---- > COL1 VARCHAR2(10) > COL2 VARCHAR2(10) > > and wrote a quick and dirty PL/SQL anonymous block: > > begin > declare > encrypted_str varchar2(10); > inp_string varchar2(10); > > begin > inp_string := '123456'; > dbms_obfuscation_toolkit.desencrypt(inp_string,'lksdjfasljf',encrypted_str); > insert into test_encrypt values (inp_string,encrypted_str); > commit; > end; > end; > / > > when I run this, I get the following error: > > dbms_obfuscation_toolkit.desencrypt > (inp_string,'lksdjfasljf',encrypted_str); > * > ERROR at line 7: > ORA-06550: line 7, column 6: > PLS-00307: too many declarations of 'DESENCRYPT' match this call > ORA-06550: line 7, column 6: > PL/SQL: Statement ignored > > now, I KNOW that they overload the procedure, they say so in the > dbmsobtk.sql file in $ORACLE_HOME/rdbms/admin > > but what am I doing wrong that it's not recognizing that I'm using varchar > not raw and accepting what I input??? > > Not urgent, but annoying > > Rachel > _________________________________________________________________ > Get your FREE download of MSN Explorer at http://explorer.msn.com > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Rachel Carmichael > INET: [EMAIL PROTECTED] > > Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California -- Public Internet access / Mailing Lists > -------------------------------------------------------------------- > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Vadim Gorbounov > INET: [EMAIL PROTECTED] > > Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California -- Public Internet access / Mailing Lists > -------------------------------------------------------------------- > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing).
begin:vcard n:Nagaraj;Vinod tel;cell:303-332-7223 tel;work:720-962-4355 x-mozilla-html:FALSE adr:;;;;;; version:2.1 email;internet:[EMAIL PROTECTED] fn:Vinod Kumar Nagaraj end:vcard
