Discussion on "Saving Rich Text Content to the DB Via an Ajax Process in APEX"

Jon Dixon · 2024-03-07T12:45:54.134Z

Introduction First of all, why am I writing about this? APEX has supported CLOBs in Rich Text Items forever (well, since APEX 22.2, anyway 😊). I am writing this post because I have a particular use case where I must pass a Rich Text Editor (RTE) pag...

Hello, guys! Would You comment that mysterious part of code?

// Something bad happened. error: function(

In fact all application's SAVE_NOTE errors goes in section success: function(

But what case will use error: function( ? I just guess that it's useless part of code...

BTW global error handling function doesnt catch pl-sql exceptions from ajax calls ((

Hi, The comment "Something bad happened." is just a comment to signify that some exception occurred in this JavaScript. PL/SQL errors should be trapped in the Ajax call and are displayed by this piece of code } else { // Stop the Interval so we don't keep trying to save after an error. clearInterval(saveInterval); // Show the error from the PL/SQL Ajax Process. apex.message.clearErrors(); apex.message.showErrors([ {type: "error", location: ["page"], message: data.status_msg, unsafe: false} ]);

Hello Jon, I attempted to reproduce your code, but I believe I may have overlooked something. When I open the page for a new record and wait for 30 seconds, I encounter a 'no data found' error. However, aside from that issue, everything else is working as expected. Could you please confirm? Thanks, Eric

Exactly! The issue lies on line 13. It arises because the JavaScript runs every 30 seconds, even for new records. The problem specifically occurs for new records where P50_NOTE_ID is null. Since this item is null, I encounter a NO_DATA_FOUND exception. Thanks.

Jon Dixon Hey John . I have the same issue as Eric Sacramento mentioned. Would you please share the debug statements that you've added to verify the value of p_note_id ? I really don't know what to do and should I add some exceptions?

Victorya Ebrahimi, as Eric mentioned, I think you are getting this error because my code assumes a record was already created in cnnt_notes before the background save kicks in. You could either create an initial record before the background save starts, or ignore the PL/SQL code in save_note_bg if p_note_id is NULL.

Search Hashnode

Saving Rich Text Content to the DB Via an Ajax Process in APEX

Responses2