search

OraOpenSource / apex-plugin-clob-load

Oracle Application Express (APEX) Plugin for form items with long text content (over 32k)
Other
21 stars 3 forks source link

'MethodNotAllowed' error in CLOB action Render #17

Open jungand opened 3 years ago

jungand commented 3 years ago

First of all let me thank you for this great solution. I'm quite new to APEX and it took me a while to find your plugin to overcome the 32k restriction.

I'm trying to use this plugin now to insert, modify and display text data between 1B and 2GB in my oracle database (11.2.0.4). While insert works very well, the plugin displays the following message when used in RENDER mode

{
    "code": "MethodNotAllowed",
    "message": "Method Not Allowed",
    "type": "tag:oracle.com,2020:error/MethodNotAllowed",
    "instance": "tag:oracle.com,2020:ecid/FqxUsLQaH9vNVGgKHl0nGA"
}

This is shown as output from the page load dyn action as if it was the result read from the database. There's no other error message, according to the tomcat logs and the debug info the application runs without problems.

The access to the database works and the message above gets displayed even if I just use "select 'hello' from dual;" as sql statement.

I've installed the TestUnitApp and it works well.

Since there's nothing more I can check I'm turning to you and kindly ask for any hint you might know.

Thank you in advance Andreas

jungand commented 3 years ago

I finally found out why the plugin didn't work in my application. It seems to work only with 'friendly URL' not set. This is very sad for me because all the other stuff has already been setup based on this feature. So I simply cannot use this cool solution. What a pity.