BLOB to CLOB using APEX_WEB_SERVICE

BLOB2CLOBBASE64 Function This function is used to convert Blob to base64Clob. Syntax: Example : References: apex_web_service.blob2clobbase64 Read more

Getting into ORDS

Firstly we need to enable ORDS. Base url : <SERVER_URL>:<SERVER_PORT>/ords/ To hide the schema name from API endpoint we put any alias in url mapping pattern. BEGIN ORDS.enable_schema( p_enabled => TRUE, p_schema => '<SCHEMA_NAME>', p_url_mapping_type => 'BASE_PATH', p_url_mapping_pattern => '<ANY_ALIAS_INPLACE_OF_SCHEMA_NAME>', p_auto_rest_auth =>... Read more