1 Reply Latest reply: Feb 13, 2013 8:10 AM by user5148377 RSS

    Oracle ApEx bug?

      My environment:

      Windows 7 32 bit
      Oracle 11g XE R2
      GlassFish Server Open Source Edition (build 5)
      ApEx Listener (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:

      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.