Is it possible to obtain the bind parameters created from a POST Body with content type x-www-form-urlencoded as a collection?
I'm faced with a problem with one of my update procedure's Resource Template. Our application is dynamic in that data instances are defined by metadata in other tables,
I am attempting to update a record but do not know until time of processing what :bind variables will be available.
An example of our POST request is like:
Content Type: x-www-form-urlencoded
Post body: 234=John&235=Watson&236=Male
Where 234 is a user defined First Name field saved in the metadata tables and is listed as a child of 12345.
An example of what my attempt at processing looks like:
- loop item instance data tied to resource
for item in
(select item_id from record_items where record_id = 12345)
--Pass item_id and value
lv_upd_stmt := 'pk_update_item('||item.item_id||', :'||item.item_id||);'
execute immediate lv_upd_stmt;
Unfortunately this fails with Bind Variable NOT DECLARED.
I hope somebody understands my problem, any information is appreciated.