How to encode a byte array for representation in an URL from Oracle / PLSQL?

Question

I am looking for a way of encoding a byte array to be representable in an URL from a procedure written in Oracle/PLSQL. It is important that the representation/encoding does not conflict with the reserved characters in an URL, like: +, /, and =.

A possible solution could be an equivalent of .NET's HttpServerUtility.UrlTokenEncode to use for "safe" URL encoding of a given byte array.

I have been searching for a while now without any luck.

Thanks in advance.

Does it need to be base64-encoded, or are you just looking for utl_url.escape? — Alex Poole
– Alex Poole, Commented May 2, 2014 at 22:32
@AlexPoole I would prefer a solution like the one that is possible in .NET - that is base64 encoding which is "safe" to use in the URL. — Lasse Christiansen
– Lasse Christiansen, Commented May 3, 2014 at 13:13

Community · Accepted Answer · 2017-05-23 12:29:30Z

0

You can encode the byte array to base64. Here is a way to perform this with the UTL_ENCODE package: https://stackoverflow.com/a/12802685/2069555

edited May 23, 2017 at 12:29

CommunityBot

11 silver badge

answered Sep 22, 2014 at 21:56

santiagop

663 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Lasse Christiansen Over a year ago

Won't work since the base64 character set contains characters reserved in the URL.

Collectives™ on Stack Overflow

How to encode a byte array for representation in an URL from Oracle / PLSQL?

1 Answer 1

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related