Re: Decode Base64 in Oracle 8i?

From: Geoff Muldoon <geoff.muldoon_at_trap.gmail.com>
Date: Wed, 21 Jun 2006 09:37:13 +1000
Message-ID: <MPG.1f0331b2dda59d5f98980f@news.readfreenews.net>

invite_at_spam.to.invalid says...
> In Oracle 10g there is UTL_ENCODE.BASE64_DECODE to decode a Base64 string.
>
> Does anybody know a solution, workaround, anything to decode Base64
> in a stored procedure in Oracle 8i?
>
> It would probably be possible to implement Base64 in PL/SQL, but maybe
> there is a simpler solution.

The PL/SQL code to encode is at:
http://www.oracle.com/technology/sample_code/tech/pl_sql/htdocs/bs64demo8i _sql.txt

You should be able to adapt it relatively easily to do a decode.

GM Received on Tue Jun 20 2006 - 18:37:13 CDT