I have recently created an Oracle Apex app in which the user can type the SQL query and run to get the Classic Report’s output.

I am sharing the link below of my GitHub repository. You can further modify the app to save the query with a Name and can recall it on click to view the report.

https://github.com/devvinish/sql-command

You can execute PL/SQL code to read the value from the database using JavaScript. Below is an example:

Click on the process tab and then click on the Ajax Callback node and create a process. And add the PL/SQL code in it to get the song words, for example:

Declare
   v_words varchar2(1000);
Begin
   select song_words into v_words
      from song where song_id = :p1_song_id;
 
  htp.p(v_words);

exception 
   when others then 
    htp.p('ERROR');
End;

Give any name to the above Ajax callback process, for example, AjxGetWords. Now call it using JavaScript below:

apex.server.process('AjxGetWords',
{
pageItems : '#P1_SONG_ID' // page items to submit
}
,
{
dataType : 'text', success : function(data)
{
if(data != 'ERROR') apex.item('P1_SONG_WORDS').setValue(data);
}
}
)

Try it.

Quick update: I have isolated the syntax issue to here this line: alert($(this.triggeringElement).attr(‘data-id’));

The Dynamic Action, as per @afzal ‘s advice correctly responds to selecting a ListView item.

I then changed the DA with the JavaScript:

var xTE = this.triggeringElement;
alert(xTE.innerText);

This correctly shows the inner text, which means that I am on the right track.

However – a new problem is that when I use the search feature of the ListView, the Dynamic Action does not work anymore. Very confused.