const g_region_us_standard

g_region_us_standard constant varchar2(255):=null

bucket regions see http://aws.amazon.com/articles/3912?_encoding=UTF8&jiveRedirect=1#s3 see http://docs.aws.amazon.com/general/latest/gr/rande.html#s3_region

const g_region_us_west_california

g_region_us_west_california constant varchar2(255):='us-west-1'

const g_region_us_west_oregon

g_region_us_west_oregon constant varchar2(255):='us-west-2'

const g_region_eu_ireland

g_region_eu_ireland constant varchar2(255):='EU'

const g_region_asia_pacific_singapor

g_region_asia_pacific_singapor constant varchar2(255):='ap-southeast-1'

const g_region_asia_pacific_sydney

g_region_asia_pacific_sydney constant varchar2(255):='ap-southeast-2'

const g_region_asia_pacific_tokyo

g_region_asia_pacific_tokyo constant varchar2(255):='ap-northeast-1'

const g_region_south_america_sao_p

g_region_south_america_sao_p constant varchar2(255):='sa-east-1'

const g_region_eu

g_region_eu constant varchar2(255):='EU'

deprecated region constants, will be removed in next release (use constants above instead)

const g_region_us_west_1

g_region_us_west_1 constant varchar2(255):='us-west-1'

const g_region_us_west_2

g_region_us_west_2 constant varchar2(255):='us-west-2'

const g_region_asia_pacific_1

g_region_asia_pacific_1 constant varchar2(255):='ap-southeast-1'

const g_acl_private

g_acl_private constant varchar2(255):='private'

const g_acl_public_read

g_acl_public_read constant varchar2(255):='public-read'

const g_acl_public_read_write

g_acl_public_read_write constant varchar2(255):='public-read-write'

const g_acl_authenticated_read

g_acl_authenticated_read constant varchar2(255):='authenticated-read'

const g_acl_bucket_owner_read

g_acl_bucket_owner_read constant varchar2(255):='bucket-owner-read'

const g_acl_bucket_owner_full_ctrl

g_acl_bucket_owner_full_ctrl constant varchar2(255):='bucket-owner-full-control'

function get_bucket_list

function get_bucket_list return t_bucket_list

get buckets

function get_bucket_tab

function get_bucket_tab return t_bucket_tab

get buckets

procedure new_bucket

procedure new_bucket(
    p_bucket_name in varchar2,
    p_region in varchar2:=null
)

create bucket

function get_bucket_region

function get_bucket_region(
    p_bucket_name in varchar2
) return varchar2

get bucket region

function get_object_list

function get_object_list(
    p_bucket_name in varchar2,
    p_prefix in varchar2:=null,
    p_max_keys in number:=null
) return t_object_list

get objects

function get_object_tab

function get_object_tab(
    p_bucket_name in varchar2,
    p_prefix in varchar2:=null,
    p_max_keys in number:=null
) return t_object_tab

get objects

function get_download_url

function get_download_url(
    p_bucket_name in varchar2,
    p_key in varchar2,
    p_expiry_date in date
) return varchar2

get download URL

procedure new_object

procedure new_object(
    p_bucket_name in varchar2,
    p_key in varchar2,
    p_object in blob,
    p_content_type in varchar2,
    p_acl in varchar2:=null
)

new object

procedure delete_object

procedure delete_object(
    p_bucket_name in varchar2,
    p_key in varchar2
)

delete object

function get_object

function get_object(
    p_bucket_name in varchar2,
    p_key in varchar2
) return blob

get object

procedure delete_bucket

procedure delete_bucket(
    p_bucket_name in varchar2
)

delete bucket

function get_object_owner

function get_object_owner(
    p_bucket_name in varchar2,
    p_key in varchar2
) return t_owner

get owner for an object

function get_object_grantee_list

function get_object_grantee_list(
    p_bucket_name in varchar2,
    p_key in varchar2
) return t_grantee_list

get grantees for an object

function get_object_grantee_tab

function get_object_grantee_tab(
    p_bucket_name in varchar2,
    p_key in varchar2
) return t_grantee_tab

get grantees for an object

procedure set_object_acl

procedure set_object_acl(
    p_bucket_name in varchar2,
    p_key in varchar2,
    p_acl in varchar2
)

modify the access control list for an object

record t_bucket

type t_bucket is record(
    bucket_name varchar2(255),
    creation_date date
)

varray t_bucket_list

type t_bucket_list is varray of t_bucket index by binary_integer

varray t_bucket_tab

type t_bucket_tab is varray of t_bucket

record t_object

type t_object is record(
    key varchar2(4000),
    size_bytes number,
    last_modified date
)

varray t_object_list

type t_object_list is varray of t_object index by binary_integer

varray t_object_tab

type t_object_tab is varray of t_object

record t_owner

type t_owner is record(
    user_id varchar2(200),
    user_name varchar2(200)
)

record t_grantee

type t_grantee is record(
    grantee_type varchar2(20),
    user_id varchar2(200),
    user_name varchar2(200),
    group_uri varchar2(200),
    permission varchar2(20)
)

varray t_grantee_list

type t_grantee_list is varray of t_grantee index by binary_integer

varray t_grantee_tab

type t_grantee_tab is varray of t_grantee