BLOB2CLOBBASE64 Function This function is used to convert Blob to base64Clob. Syntax: APEX_WEB_SERVICE.BLOB2CLOBBASE64 ( p_blob IN BLOB) RETURN CLOB; Example : declare l_clob CLOB; l_blob BLOB; begin SELECT BLOB_CONTENT INTO l_BLOB FROM APEX_APPLICATION_FILES WHERE name = :P1_FILE_NAME; l_CLOB := apex_web_service.blob2clobbase64(l_BLOB);... Read more
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