CODEWITHSUNDEEP
sqljsonoracle-databaseplsqloracle-apex
Nuled
Nuled

Reputation: 51

Oracle APEX: Error: SyntaxError: Unexpected end of JSON input

I'm having an issue where I've got a button that's action is to 'submit page' upon being clicked. The code then executes a PL SQL statement:

IF :REQUEST = 'btn_create_company' THEN
    INSERT INTO COMPANIES (company_name) VALUES(:COMPANY_NAME);

However, when the code comes to execute, whilst it is adding the entry to the database, I'm getting this error on the client which is preventing the page from redirecting after processing:

Error: SyntaxError: Unexpected end of JSON input

I don't understand why this is happening as I'm confident there's nothing wrong with the above statement.

Upvotes: 2

Views: 9442

Answers (3)

djm
djm

Reputation: 1

I was encountering a similar error when operating the last page in a chained dialog (aka "wizard") I had created.

The cause of my issue was that I had created a branch on the "After Submit" with the Behaviour/Type attribute set to "PL/SQL Procedure" and then had the code I wanted to be executed within the PL/SQL code attribute. When the "Finish" button was clicked, I was seeing the same error.

My resolution was to delete the branch and instead to use Create Process, with the Identification/Type set to "PL/SQL Code" and then placing the code I wanted to be executed within the "Source/PL/SQL Code" attribute.

Upvotes: 0

Manasse
Manasse

Reputation: 160

Ok, so I get this problem too, It's when I submit the page but instead of reload the whole page, I'm running a process and stay there.

The process itself works well, however I get the error message, just like you.

So I don't get the a solution, but found a workaround by adding this to the end of my process:

    apex_json.open_object;  
    apex_json.write('success', true);  
    apex_json.close_object;

Upvotes: 3

RLOG
RLOG

Reputation: 630

You are missing the page number on :COMPANY_NAME. It should be something like :P1_COMPANY_NAME

Upvotes: 0

Related Questions