Thanks for you reply. I have 2 questions.
1. It worked for Auto PLSQL will it work with rest handler using PL/SQL Block as i did it.
2. As i see that it works, You are passing JSON. Is it Oracle 11gR2 or 12c database. I am using 11gR2
Thank Jeff, It worked for me but with 11gR2. but in AUTO PLSQL. Its not working with REST handler i am not sure what error i am doing. following is my rest handler code.
But i have some questions:
1. This works in AUTO PLSQL mode with INS_C in uppercase
2. BUT below does not work - Notice pkg1/ins_c in lower case
I'm not sure if this is advisable, but you could always qualify the procedure name inside the package with double quotes, e.g.:
...which gives you a lower case url mapping.
There is a p_object_alias parameter in the ORDS.ENABLE_OBJECT procedure - but as far as I can tell that can only alias the package name, not the procedure names inside.