Skip to Main Content
Forums

ORDS, SODA & JSON in the Database

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

BLOB(pdf) download issue in Apex

Rajesh DavidJul 8 2014

Hi,

In Apex Application We are not able to download blob(pdf file) which has % character in the filename.

In Application(Apex) we are getting below error

REST DATA SERVICES

500 - Internal Server Error

In Listener we are getting below error


Oracle REST Data Services version : 2.0.8.163.10.40

Oracle REST Data Services server info: Grizzly/1.9.49

Jul 3, 2014 2:24:02 AM com.sun.grizzly.Controller logVersion

INFO: GRIZZLY0001: Starting Grizzly Framework 1.9.49 - 7/3/14 2:24 AM

Jul 3, 2014 2:24:02 AM oracle.dbtools.standalone.Standalone execute

INFO: http://localhost:7777/apex/ started.

Jul 3, 2014 2:24:44 AM oracle.dbtools.rt.web.WebErrorResponse internalError

SEVERE: contains illegal character for hexBinary: _A

java.lang.IllegalArgumentException: contains illegal character for hexBinary: _A

  at javax.xml.bind.DatatypeConverterImpl.parseHexBinary(Unknown Source)

  at javax.xml.bind.DatatypeConverter.parseHexBinary(Unknown Source)

  at oracle.dbtools.rt.web.PercentEncoding.decodeOctet(PercentEncoding.jav

a:134)

  at oracle.dbtools.rt.web.PercentEncoding.decode(PercentEncoding.java:89)

  at oracle.dbtools.rt.web.QuotedStringValue.decodeText(QuotedStringValue.

java:85)

  at oracle.dbtools.rt.web.QuotedStringValue.normalize(QuotedStringValue.j

ava:95)

  at oracle.dbtools.rt.web.QuotedStringValue.<init>(QuotedStringValue.java

:20)

  at oracle.dbtools.rt.web.QuotedStringValue.decode(QuotedStringValue.java

:41)

  at oracle.dbtools.rt.web.QuotedStringScanner$TokenIterator.quotedToken(Q

uotedStringScanner.java:158)



Thanks in advance

Rajesh

Comments

sb92075

How do I ask a question on the forums?

https://forums.oracle.com/message/9362002#9362002

Emad Al-Mousa

Hi sb92075,

i didn't get you ......what is the problem with my question ?

sb92075

[oracle@localhost ~]$ oerr ora 28575

28575, 00000, "unable to open RPC connection to external procedure agent"

// *Cause:   Initialization of a network connection to the extproc agent did

//           not succeed. This problem can be caused by network problems,

//           incorrect listener configuration, or incorrect transfer code.

// *Action:  Check listener configuration in LISTENER.ORA and TNSNAMES.ORA, or

//           check Oracle Names Server.

1 person found this helpful
Emad Al-Mousa

i have checked the configuration of the listener.ora and tnsnames.ora and they are identical to what is needed from the documentation.

So, when i start up the listener the "external procedure" services comes up successfully.

Please note that per Oracle Documentation theses configurations are "NOT" required with Oracle 11g (my database version), setting the configuration from "extproc.ora" is only needed.

i have used the parameter: SET EXTPROC_DLL=ANY

1 person found this helpful
sb92075

file a bug report with MOS

Emad Al-Mousa
Answer

after extensive troubleshooting, i found out that this will occur in one of two situations:

1. the .so external procedure library is corrupted.

OR

2. the .so external procedure library is a 32 bit.......to check that use the Unix Command ( file lib.so) the output should give you 64bit

Marked as Answer by Emad Al-Mousa · Sep 27 2020
1 - 6
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Aug 5 2014
Added on Jul 8 2014
#apex
0 comments
1,253 views