Register Schema with ORDS From Sql Developer
Open sql developer and open connection for your schema
your Sceham not registerd for ORDS Yet
Right Click on your connection > Rest Service > Enable Rest Service
Click Enable Rest Service
choose Your schema alias
Press NEXT
You can see Code from SQl Tab
Press Finish
we will find that our schema is register with ORDS
We can Use the Code Direct in SQL Developer
DECLARE
PRAGMA AUTONOMOUS_TRANSACTION;
BEGIN
ORDS.ENABLE_SCHEMA(p_enabled => TRUE,
p_schema => 'RE',
p_url_mapping_type => 'BASE_PATH',
p_url_mapping_pattern => 're',
p_auto_rest_auth => FALSE);
commit;
END;
----
thanks
ليست هناك تعليقات:
إرسال تعليق