UC_FROALA_SAMPLE_REST

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
• imageBrowse
• imageUpload
• imageDelete
• imageBrowseFolder
• imageUploadFolder

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
);