Password Encryption

[kwil38]

I'm trying to create (what I thought would be) a simple procedure to Base64 encode a password using the utl.encode.base64_encode function.

When I try to compile the procedure, I receive the following error on the "UTL.ENCODE.BASE64_ENCODE..." line -
PLS-00103: Encountered the symbol "RAW" when expecting one of the following:

(

Anyone have any ideas???? Below is my code....

CREATE OR REPLACE PROCEDURE WEHCO_PASSWORD_ENCRYPTION
(i_password RAW,
o_password RAW)
IS
BEGIN
UTL.ENCODE.BASE64_ENCODE(i_password IN RAW);
o_password := RAW;
dbms_output.put_line(o_password);
END;
/

Thanks,
Kent

 

[sem]

UTL.ENCODE.BASE64_ENCODE(i_password [b]IN RAW[/b]);

Type is required in declaration, not in procedure call.

Regards, Dima

http://seminihin.narod.ru

 

[kwil38]

When I take the IN RAW out I receive another error:

PLS-00201: identifier 'UTL.ENCODE' must be declared

My code now looks like this:

CREATE OR REPLACE PROCEDURE WEHCO_PASSWORD_ENCRYPTION
(i_password IN RAW,
o_password OUT RAW)
IS
BEGIN
UTL.ENCODE.BASE64_ENCODE(i_password);
o_password := RAW;
dbms_output.put_line(o_password);
END;
/

 

[LKBrwnDBA]

You need to use the correct function: UTL_ENCODE and use it correctly:

   o_password := UTL.ENCODE.BASE64_ENCODE(i_password);

----------------------------------------------------------------------------
The person who says it can't be done should not interrupt the person doing it. -- Chinese proverb

 

[LKBrwnDBA]

Ooops, typo:

 o_password := UTL_ENCODE.BASE64_ENCODE(i_password);

----------------------------------------------------------------------------
The person who says it can't be done should not interrupt the person doing it. -- Chinese proverb