Java URL decoder in Oracle

[Moose423956]

I have an Oracle data input which originates from Japan, and has been encoded into the following format:

%u3053%u306E%u30B3%u30FC etc

I need to be able to decode that back into the Japanese characters within PL/SQL. There's a utility called the Java URL Decoder, as shown here.

Does anyone know how to apply the Java URL Decoder within PL/SQL? Or if not that specifically, then any other standard Java script, and I could try to do the same.

Cheers
Moose

 

[Jason]

Create a class with a static method utalising the decoder and register it as a Java Stored Procedure.

you should find this link useful

http://www.oracle.com/technology/sample_code/tech/java/jsp/oracle9ijsp.html

 

[Moose423956]

Create a class with a static method utalising the decoder and register it as a Java Stored Procedure.

you should find this link useful

http://www.oracle.com/technology/sample_code/tech/java/jsp/oracle9ijsp.html

Like in the example called "PL/SQL Stored Procedure invoking Java Stored Procedure "?

 

[Jason]

yup