Hi,
For a proof of concept, I am using Apex.oracle.com.
I want to consume a Rest-Api and store the data in a local table.
I am following the steps as can be viewed in https://www.youtube.com/watch?v=9ZZBXI6y0QU
But when I come to the 'Save and Run' the Job Status goes to Scheduled and hangs. The job does not get executed and the local table does not get populated.
I can understand that Oracle does not want to grant users of Apex.oracle.com the 'schedule' jobs privileges. But does anybody know how I can manage to get this job run only once. I do not need a schedule. I only need the fetch and repopulate the data on command. Preferably without using jobs.
So what does Apex call (in the job) that does the magic of populating the local table?
Thanks in advance
Geert