Skip to Main Content

Intelligent Advisor

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!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

Getting a Bad Request error while trying to call the same project using Rest API.

Sourabh KshitizJan 8 2021

We have developed a Project ,which needs to be called to 2 times one by one. The issue is when it is being called the first time through WSO2(middleware) in a form of JSON request via REST API ,everything is working fine but when it is being called the second time with the same JSON request we are getting Bad Request error with the detail being " Error reading JSON request data: Illegal control code at 1".
Can anybody suggest what is happening wrong in the second call.
{
"type": "HTTP://www.w3.org/Protocols/rfc2616/rfc2616-sec10.html#sec10.4.1",
"title": "Bad Request",
"detail": "Bad Request: Error reading JSON request data: Illegal control code at 1 [character 2 line 1]",
"internal-code": ""
}

Comments

Hoek
Does :NEW.UUID have any value?
Usually these columns are populated through calls to some SEQUENCE.NEXTVAL value.
How are you populating the column?
Solomon Yakobson
Are you creating trigger using OEM and target database 9i? If so, there is a bug. Use other tool, e.g. SQL*Plus.

SY.
752032
In this case the UUID column is a nvarchar2(100) and is provided in the insert action....

Thanx for your response.
752032
No, I'm using OEM from client 10g and oracle database 10g

Thanx for your response...
Syed Ullah
Try putting a DBMS_OUTPUT.PUT_LINE() in your trigger to print the value of :NEW.UUID
and then do an insert in SQLPLUS to see what value gets printed for :NEW.UUID.
752032
The problem is: I can't save the trigger, it shows me the error message: "Missing IN or OUT parameter at index:: 1" and fails...
I'm working over the OEM
Syed Ullah
Try saving it using SQLPLUS and if that works that may indicate some bug on the OEM side.
752032
When I execute the script:

CREATE OR REPLACE TRIGGER "KIKO"."TR_INSERT_PERSON" AFTER
INSERT ON "KIKO"."PERSON" FOR EACH ROW BEGIN
INSERT INTO CHANGETABLE (ROWGUID, OPERATION, DATEOPERATION, TABLEID) VALUES (:NEW.UUID, 2, (SELECT SYSDATE FROM DUAL), 'PERSON');
END;Connect sys/****@orcl AS SYSDBA

It shows me the warning: "Trigger created with compilation errors."
It seems like a syntax or semantic error
Syed Ullah
Type 'show error' to see the errors.
Solomon Yakobson
Answer
Try the following in SQL*Plus:
CREATE OR REPLACE
  TRIGGER KIKO.TR_INSERT_PERSON
    AFTER INSERT
    ON KIKO.PERSON
    FOR EACH ROW
    BEGIN 
        INSERT
          INTO CHANGETABLE(
                           ROWGUID,
                           OPERATION,
                           DATEOPERATION,
                           TABLEID
                          )
          VALUES (
                  :NEW.UUID,
                  2,
                  SYSDATE,
                  'PERSON'
                 );
END;
/
SHOW ERRORS TRIGGER KIKO.TR_INSERT_PERSON
SY.
Marked as Answer by 752032 · Sep 27 2020
752032
The error message is: "Missing IN or OUT parameter at index:: 1"
752032
Seems like it works!!! Could you explain me what happened???
Solomon Yakobson
user12572223 wrote:
Seems like it works!!! Could you explain me what happened???
Could you provide create table statements for tables PERSON and CHANGETABLE.

SY.
1 - 13

Post Details

Added on Jan 8 2021
5 comments
1,121 views