8i | 9i | 10g | 11g | 12c | 13c | 18c | 19c | 21c | Misc | PL/SQL | SQL | RAC | WebLogic | Linux

Home » Misc » Here

Comments for Oracle REST Data Services (ORDS) : Auto PL/SQL


Anonymous said...

Hi Tim,
Can you also post a procedure or function that takes a UDT as input ? I am stuck on how to pass UDT via POST . I can get all UDT returned or OUT but passing UDT is not happening. I tried following para as IN parameter with no luck
{"empno": 7369,"ename": "SMITH"},{"empno": 7499,"ename": "ALLEN"}

Tim... said...

Hi.

I don't think Auto PL/SQL is the solution to user-defined types. I would do something like the method described here.

https://oracle-base.com/articles/misc/oracle-rest-data-services-ords-restful-web-services-handling-complex-json-payloads

Cheers

Tim...

Rajan said...

Resolved: I have to use same name as in parameter variable and post with data that i want as IN in package.

example, my_func(in_emp_record_arr in emp_record_arr ), and use following
{"in_emp_record_arr": [{"empno": 7369, "ename": "SMITH"},{"empno": 7499,"ename": "ALLEN"} ]
Key here is to pass same paramter_name like for me in_emp_record_arr with data. I use data as raw though

DO NOT ask technical questions here! They will be deleted!

These comments should relate to the contents of a specific article. Constructive criticism is good. Advertising and offensive comments are bad and will be deleted!

If you post personal information (name, email address etc.) you are agreeing to them being stored and displayed. Feel free to remain anonymous.