This discussion is archived
1 Reply Latest reply: Feb 13, 2013 6:10 AM by user5148377 RSS

Oracle ApEx bug?

user5148377 Newbie
Currently Being Moderated
My environment:

Windows 7 32 bit
Oracle 11g XE R2
GlassFish Server Open Source Edition 3.1.2.2 (build 5)
ApEx Listener 2.0.0.354.17.05 (deployed as an application in the above web server)
ApEx 4.2.1

My Problem:

1. Define a RESTful Resource Service Module in ApEx with the following attributes:

URI template: test/
Method: Get
Source Type: Media Resource
Requires Secure Access: No
Pagination Size:
Source:

SELECT 'application/xml', XMLAGG(XMLELEMENT("EmpId", e.employee_id))
FROM hr.employees e

2. Click the "Test" button in the ApEx Resource Handler UI and witness the following error:

500 - Internal Server Error
resource.template.evaluationError during evaluation of resource template: GET geo/, SQL Error Code: 600, SQL Error Message: ORA-00600: internal error code, arguments: [kolrghte: hash table not exist], [], [], [], [], [], [], [], [], [], [], []

3. Modify the "Source" attribute for the Media Resource as follows:

SELECT 'application/xml', XMLELEMENT("EmpId", e.employee_id)
FROM hr.employees e
WHERE ROWNUM = 1

4. Click the "Test" button in the ApEx Resource Handler UI and note that XML is returned as expected.

Both of the above queries used to populate the "Source" attribute can be executed from SQLPlus without issue.

I am not experiencing any issues with the other Resource Handler types.

Any assistance would be much appreciated.

JR.

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points