Below you'll find a list of all posts that have been tagged as “ORDS”
New Oracle REST Data Services (ORDS) drop today. Per usual, mostly bug fixes And per usual, sometimes we like to sneak in new features as well, and this release is no different. You can now have ORDS automatically create POST handlers for executing your PL/SQL. This is a LOW CODE solution. You could of course ALWAYS roll your own RESTful …
For all of my ORDS demos, I’m running it as a standalone process. There’s no Tomcat or Apache involved – and that’s OK. Your needs may require otherwise, and that’s OK too. When running in a standalone configuration like this, ORDS’ HTTP(S) functionality is being delivered by an embedded Jetty web server. Jetty is an Eclipse project. Very cool stuff …
ORDS_PUBLIC_USER is the database user that’s used to create your ORDS connection pool(s). Each database configured with ORDS gets one. When you publish a RESTful Service under HR on database X, ORDS resolves the call to the proper jdbc connection pool, then proxy connects from ORDS_PUBLIC_USER to user HR, and runs the SQL or PL/SQL. So, now imagine what happens …
I had a very, very enjoyable time at the Great Lakes Oracle Conference this week in Cleveland (OHIO! – Just in case Joel is reading this.) About 400 people attended, and I think it’s become one of the best conferences in the US, esp for the bang you get for your buck. I did two talks. For the first one, …
Someone asked: I see reference to a ‘$URI’ in an ORDS GET Handler example, can you explain what this is? Yes. Or, I can with the help of some of our DOCS. The appropriate section would be: Columns in result sets whose first character is $ are given special treatment, they are assumed to denote columns that must be transformed …
One of the new features in version 4.2 of SQL Developer is the ability to work with your ORDS Restful Services directly in the database tree. Here’s a video demo… Features via Screenshot Some of you don’t have access to YouTube at work (or at home apparently), so here’s a quick snapshot. As you make changes here, the REST Services, …
Can you? YES. Absolutely, even. Go from your app to your Oracle Database resources via REST (GET|POST|PUT|DELETE), and your responses come back via JSON. No APEX required. And even better, you can have ORDS up and running in less than 5 minutes. Ok, but what about ORDS & APEX? If you want to provide a RESTful API for your Oracle …
In the current issue of Oracle Magazine, you can read all about how to get started with the Auto REST feature of Oracle REST Data Services…or in other words, how to automatically make Tables and Views available via REST APIs. A table or view is very easy to consider as a resource in the REST model. What ORDS does is …
Yesterday I talked about how to grab the output returned from your stored procedure when executing via Oracle REST Data Services. The example was: INSERT a new record into a table. Return the new employee ID and the total number of employees in the table. So we just needed 2 parameters for our handler to catch the two integers returned, …
I have a very simple, and not very elegant stored procedure. CREATE OR REPLACE PROCEDURE ADD_EMP ( P_EMP_NAME IN SIMPLE_EMP.name%TYPE, P_EMP_SALARY IN SIMPLE_EMP.SALARY%TYPE, P_OUT_ID OUT SIMPLE_EMP.id%TYPE, P_OUT_TOTAL OUT INTEGER ) AS BEGIN INSERT INTO SIMPLE_EMP (name, SALARY) VALUES (P_EMP_NAME, P_EMP_SALARY) RETURN id INTO P_OUT_ID; SELECT COUNT(id) INTO P_OUT_TOTAL FROM SIMPLE_EMP; EXCEPTION WHEN OTHERS THEN HTP.print(SQLERRM); END; Sidebar: Like, …