I'm using Oracle Rest Data Services to build an app.
I can easily read & write with something like this GET http://example.com/foo/bar that runs query SELECT * FROM bar or
POST http://example.com/foo/bar
{
"first": "a'b",
"second": "c,d"
}
that runs query INSERT INTO bar (first, second) VALUES (:first, :second)
Where query parameters are bound from request body.
Now, I'd like to build a route that run a dynamic query.
I can do that with one binding param, eg.:
POST http://example.com/foo/query
{
"query": "DELETE FROM bar WHERE first = :param",
"param": "a'b"
}
that runs query
BEGIN EXECUTE IMMEDIATE :query USING :param; END;
But I don't know how to do it with multiple params. For eg.
POST http://example.com/foo/query
{
"query": "DELETE FROM bar WHERE first = :first AND second = :second",
"bindings": "first,second",
"first": "a'b",
"second": "c,d"
}
The query should be something like
DECLARE
params ...? -- (params variable should set USING list from :bindings request param)
BEGIN
EXECUTE IMMEDIATE :query USING params;
END;
Any idea?
