Skip to Main Content

ORDS, SODA & JSON in the Database

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!

Good practice logging requests in a database table

juliojgsJun 21 2022

Hi,
I'm recording the requests I receive in a database table for some of my services, in order to be able to follow up errors reported by the users when things go wrong.
So I created a table where I store metadata, like the timestamp at the beginning and end of the operation. I also store the method, the relative url, and even the :body_text in a clob.
I'm not sure if this is good practice, maybe they are already being stored somewhere in the data dictionary and I am doing redundant work. Do you know if this kind of info is already stored?
Also, I realized :body_text is empty if they send the parameters in header instead of in json.
Is there a parameter with the url I can use? (now I'm writing it literal).
Thanks.

Comments
Post Details
Added on Jun 21 2022
1 comment
281 views