Parameters and Binds for your RESTful Services

thatjeffsmith Database Stuff 0 Comments

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;   …

Deploying Oracle REST Data Services from Oracle SQL Developer

thatjeffsmith SQL Developer 23 Comments

REST is Representational State Transfer for short. It’s how a lot of the Internet works for long, and I’m not going to tell that story. But. When you see an application making PUT or GET requests over HTTP or HTTPS, that’s REST. Anyways, before I …

Related Posts Plugin for WordPress, Blogger...