Nearly 7,000,000 Oracle professionals use SQL Developer on a regular basis. Have a question about Oracle SQL Developer? Searched this blog and couldn’t find the answer? Ask away!
If your question is about Oracle Database, SQL, PL/SQL, etc – go Ask Tom!
Feel free to ask anything you want, but I’ll feel free to send you to Support or our Forums if it goes sideways.
Note: This page has turned out way more successful(?) than I would have ever imagined. Please keep these things in mind when asking questions.
- I am NOT support. Don’t expect me to log bugs for you, or give you official timelines on bug fixes, enhancements, or product releases.
- I AM NOT SUPPORT. Don’t open an SR with My Oracle Support AND leave a question here. Pick one and go with it, and when in doubt, go to My Oracle Support.
- I try to answer questions as quickly as possible. If you don’t get an answer, ask me for an update. I may have just forgotten or overlooked your request.
Go!
7,991 Comments
Hi Jeff
I’m facing some issue with Oracle APEX 24.2 to get proper RESFul API based on a package for three tables.
In fact I could generate the table packages and then created the AutoREST objects, but the final endpoints creted does not seem what I expected.
I followed the steps :
1o) Open SQL Workshopand acess Utilities ==> Method on tables
2o) Put package name : PKG_Customer
3o) Select the three tables to crete the package : tcustomer, tcity, tsalesperson
4o) Created the package PKG_Customer
5o) Then I went to SQL Workshop ==> RESTFul Services == Create AutoREST objects, it generated the endpoints on full URL : http://localhost:8080/ords/wsgcash/RESTpkg_customer/
6o) Open SQL Developer Web to check the REST Objects ==> REST ==> AutoREST
7o) Check the PKG_Customer API code PKG_Customer ==> View OpenAPI
a) Two of the some endpoints created for the tcity table were /GET_TCITY/1 and /GET_TCITY/2
b) Although they were named as GET_TCITY they were defined as POST verbs and required a parameter in the request body
c) This is the endpoint url : http://localhost:8080/ords/wsgcash/RESTpkg_customer/GET_TCITY/1
d) this is the cURL call
curl -X ‘POST’ \
‘http://localhost:8080/ords/wsgcash/RESTpkg_customer/GET_TCITY/1’ \
-H ‘accept: application/json’ \
-H ‘Content-Type: application/json’ \
-d ‘{
“p_cit_id”: 1
}’
e) it does ont run and showed the error :
404 Error: Not Found
Response body
{
“code”: “NotFound”,
“message”: “Not Found”,
“type”: “tag:oracle.com,2020:error/NotFound”,
“instance”: “tag:oracle.com,2020:ecid/aDbnmbom6-qQqzCqNT_tuQ”
}
f) I also run this requst in Postman but I had the same 404 error
I also opened this request on stackoverflow and provided screenshots of each step.
https://stackoverflow.com/questions/79675561/oracle-apex-24-restful-services-url-endpoints-verbs-does-not-work
Why the endpoints and verbs created by using “SQL Workshop ==> RESTFul Services ==> Create AutoREST Objects” based on package are generating only POS|T verbs and those are not working as expected?
Did I miss some step or am I using the SQL Web Developer in the wrong way?
I appreciate your comments on this.
Thanks.
I answered your Question on StackOverflow.
If you do need to build your own API vs rely on Auto feature, you might find this article helpful.
Hi Jeff,
I am trying “PROJECT” feature in SQLcl. Is there a config option to set liquibase schema?
No, that’s not supported with Projects command, directly.
However, if you inspect the install.sql script, you can see the liquibase commands…and you could add the -liquibase-schema-name parameter to the update changeSet command. And if you do that, it’s on you to do it, correctly, going forward as you would risk breaking your installer, as we won’t know what you’re doing.
Hi Jeff, I was wondering if you knew if there is an (official) effort at Oracle to create a model context protocol (MCP) server to allow Gen-AI enabled tools like VS Code to be context aware of Oracle databases? Thanks!
Yes I know.
I think you will like the answer, very very very soon.
Thanks Jeff. I’ll keep an eye out for the MCP announcement.
I appreciate you for taking the time to answer the question..and thank you for the tip.
Of course, any time!
Hi Jeff,
I started using the extension 25.1.1 recently and connected it to EBS 12.2.14, while I can use sql worksheet and run queries I am not having any success populating the object tree, should this be working or is there a trick to it. I am wondering if the reason is the amount of data that needs to be pulled in for browsing through the objects. Every presentation on line that I saw is using a simple DB, just not with number of items EBS database contains.
Thank you
Peter
We don’t care how ‘big’ your database is.
We’re querying the dictionary for objects, and it tells us what is there.
You can see the queries we’re running in the Output panel, with category switched to SQL Developer Log. In Extension preferences, set the extension logging to ‘TRACE.’
We’re basically querying the contents of the ALL_ views like ALL_OBJECTS, ALL_TABLES, etc.
never mind sorry about that, I figured it out after going into Other Users and then applying filter, it works as would expect. I need little more time discovering the tool.
Thank you