This forum is currently locked. You can't register or post questions at this time. (read more)

Deocode 64 Base code

All posts relating to Oracle PL/SQL development.

Moderator: Tim...

venkat
Member
Posts: 30
Joined: Sat Jan 05, 2013 5:13 am

Deocode 64 Base code

Postby venkat » Thu Jul 17, 2014 11:15 am

Hi Tim,

I want to decode to base64_Deocde
which was encoded by sql Server base64_Encode

i mean SQL server PPL Encoding to 64baseEncode and sendind to oracle database and now i need to decode to 64baseDecode

How i can achieve,tried using Select utl_encode.base64_decode('UGFzc3dvcmRAMTIz') from dual

But Getting Error like this ORA-01465 invalid Hex Number

UGFzc3dvcmRAMTIz - is encoded by SQL Server 64Base Encode

Thanks & Regards
Venkat

Tim...
Site Admin
Posts: 18437
Joined: Mon Nov 01, 2004 5:56 pm
Location: England, UK
Contact:

Re: Deocode 64 Base code

Postby Tim... » Thu Jul 17, 2014 11:32 am

Hi.

Well, that depends on a number of factors.

- What format does the encode leave the text in? RAW, HEX (VARCHAR representation of the RAW).
- Depending on the output, you may have to cast to raw, the decode...

This is how I do it normally:

http://www.oracle-base.com/dba/script.p ... encode.sql
http://www.oracle-base.com/dba/script.p ... decode.sql

Cheers

Tim...
Tim...
Oracle ACE Director
Oracle ACE of the Year 2006 - Oracle Magazine Editors Choice Awards
OakTable Member
OCP DBA 7.3, 8, 8i, 9i, 10g, 11g
OCP Advanced PL/SQL Developer
Oracle Database: SQL Certified Expert
My website: http://www.oracle-base.com
My blog: http://www.oracle-base.com/blog


Return to “Oracle SQL and PL/SQL Development”

Who is online

Users browsing this forum: No registered users and 3 guests

cron