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

A Tale of Two Styles of URIs and Parameters w/ORDS

thatjeffsmith Database Stuff 0 Comments

I have a RESTful Service that accepts a bind value to a query that ORDS will run for me. How do I pass that bind to ORDS? You can do it explicitly be defining it as part of the URI. Or, you can use the …

Related Posts Plugin for WordPress, Blogger...