Skip to main content

Package UC_FROALA_SAMPLE_REST

The package is used by the plug-in sample RESTful service to handle images in the plug-in sample application. Images are uploaded to the sample application table UC_FROALA_SAMPLE_BLOBS.

Procedures​

The package exposes the following procedures:

imageGet​

The procedure displays an image uploaded using the sample RESTful service template upload template.

procedure imageGet( 
  p_file_id                       in number, 
  p_status                        out integer, 
  p_location                      out varchar2
);

imageBrowse​

The procedure is used by the sample RESTful service template browsing uploaded images using the plug-in image browser.

procedure imageBrowse(  
  p_session_id     in number,  
  p_access_token   in varchar2,
  p_app_user       in varchar2,
  p_application_id in varchar2,
  p_page_id        in varchar2,
  p_status         out integer
);

imageUpload​

The procedure is used by the sample RESTful service template uploading images.

procedure imageUpload( 
  p_access_token                  in varchar2, 
  p_session_id                    in varchar2, 
  p_application_id                in varchar2, 
  p_page_id                       in varchar2, 
  p_app_user                      in varchar2,     
  p_image_name                    in varchar2, 
  p_image_content                 in blob, 
  p_image_mimetype                in varchar2, 
  p_image_temp_id                 in varchar2,
  p_status                        out integer, 
  p_location                      out varchar2 
);

imageDelete​

The procedure is used to delete an image using RESTful service template deleting images and the plug-in image browser.

procedure imageDelete( 
  p_access_token                  in varchar2, 
  p_session_id                    in varchar2, 
  p_application_id                in varchar2, 
  p_page_id                       in varchar2, 
  p_app_user                      in varchar2, 
  p_image_id                      in varchar2, 
  p_status                        out integer 
);

imageBrowseFolder​

The procedure is used by the sample RESTful service template browsing images with custom query parameter :folder. The query parameter is computed on the fly using the plug-in dynamic action Image Browser Parameters.

procedure imageBrowseFolder(  
  p_session_id                    in number,  
  p_access_token                  in varchar2,
  p_app_user                      in varchar2,
  p_application_id                in varchar2,
  p_page_id                       in varchar2,
  p_folder                        in varchar2,
  p_status                        out integer
);

imageUploadFolder​

The procedure is used by the sample RESTful service template uploading images with custom query parameter :folder. The query parameter is computed on the fly using the plug-in dynamic action Upload parameters.

procedure imageUploadFolder( 
  p_access_token                  in varchar2, 
  p_session_id                    in varchar2, 
  p_application_id                in varchar2, 
  p_page_id                       in varchar2, 
  p_app_user                      in varchar2, 
  p_image_temp_id                 in varchar2,    
  p_image_name                    in varchar2, 
  p_image_content                 in blob, 
  p_image_mimetype                in varchar2, 
  p_folder                        in varchar2,
  p_status                        out integer, 
  p_location                      out varchar2 
);