Skip to Main Content
Forums

APEX

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!

Problem with APEX 22.1 and REST API PUT/POST

hello everyone,
I need your advice / help with using APEX and REST API PUT / POST on an AutoREST table.
Currenty this is what i've done
In Shared Component -> REST Data Source i've created a DATA source based on the AutoREST Table. I've 3 REST source operation (GET, POST and PUT)
In the PUT, i have :id in the URL pattern, in the request body template i've clicked autogenerate
in the Database Operation i've set as Update Row
In the Operation parameter, i have set like this
image.pngand inside the save process i have this
image.pngI've see that the apex_exec.execute_web_source is deprecated, What else i can use?
So, after all that, when i click on save button and the process do his job, in the APEX Debug i've see this error
image.pngIf i test with Postman, it's working really good!
But inside APEX, i can't POST or PUT without error, but GET is working great!
and if i look on the data mapping every fields are empty
image.pngAny clues about whats going on?

Thanks for your help

Comments

gimbal2
Lol, you're trying to run 'java.exe' aren't you? Perhaps you should start at the beginning - with a book!
EJP
When I try to use it, I get a DOS window that pops up for an instant then disappears - then nothing else happens
That's what it's supposed to do. Your expectations are misplaced. What were you expecting? and why?
955403
How do I open a session in order to write JAVA code? What do I need to download then?
gimbal2
952400 wrote:
How do I open a session in order to write JAVA code? What do I need to download then?
A text editor. You did not download Visual Studio or something, you only have the tools to be able to compile and run stuff. Command line tools. Java is freedom and thus requires intelligence and reasoning to be able to use it properly, nobody is going to hold your hand and tell you what to use and how to do things. Its all up to you to discover that through reading, studying and experimentation. If that is not your thing you may want to consider switching to .NET.

There are also Integrated Development Environments (IDE) which are more complete, of which the most popular ones are Netbeans and Eclipse. You'll have to try them out to see which one you like more. But I would start with some basic research so you stop making wrong assumptions.
955403
Gimbal2 - Thank you for your time and trouble, and I will make one final stab at this: If I had wished to create a Word document, then I would open an MS Word session, type my sentences, and save the document. Likewise, I wish to open a Java session, type my logic, save it, compile it then execute it. It seems to me to be the most basic of requirements – or am I asking for too much?
EJP
You're asking for things that don't exist in the Java distribution, and you are just reiterating your erroneous assumptions instead of trying to learn from the very full reply you got from gimbal2.
955403
ok, thank you.
gimbal2
952400 wrote:
Gimbal2 - Thank you for your time and trouble, and I will make one final stab at this: If I had wished to create a Word document, then I would open an MS Word session, type my sentences, and save the document. Likewise, I wish to open a Java session, type my logic, save it, compile it then execute it. It seems to me to be the most basic of requirements – or am I asking for too much?
Its funny how you bring up Microsoft stuff as an example :) Really, Microsoft .NET with Microsoft Visual Studio. I have this 'feeling' that that's where you belong and you will thrive.

But yeah Eclipse or Netbeans when you want to "go Java". Like I already mentioned.
1 - 8

Post Details

Added on Sep 22 2022
#apex, #apex-discussions, #apex20-2, #oracle-apex, #rest
6 comments
1,454 views