I am experimenting with AutoRest and have used the RestFul Services Wizard from SQL-Developer to rest-enable a view.
This all works just fine and as expected.
But now I want to undo what has been created by the AutoRest functionality but I cannot manage to drop everything that has been automatically created.
The query
select * from USER_ORDS_OBJECTS where parsing_object = 'XXCPC_VATCODES_V'
keeps showing me a row.
Even after executing
ORDS.DROP_REST_FOR_OBJECT( p_object=>'XXCPC_VATCODES_V' );
the query still gives me a row.
When I drop the view entirely the row no longer shows. But when I recreate the object (without Rest-enabliing it again), the row appears again (and the object_alias I assigned it the first time I enabled the restfull services for this objects, reappears.
How can I delete all objects that Oracle has automatically created?