File: ora_UpdateCnsTab_interface.sql

package info (click to toggle)
dpm-postgres 1.7.4.7-1
  • links: PTS, VCS
  • area: main
  • in suites: squeeze
  • size: 13,788 kB
  • ctags: 10,782
  • sloc: ansic: 146,136; sh: 13,362; perl: 11,142; python: 5,529; cpp: 5,113; sql: 1,790; makefile: 955; fortran: 113
file content (15 lines) | stat: -rwxr-xr-x 1,072 bytes parent folder | download | duplicates (8)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
create or replace package  updatecnstab_pck  AUTHID CURRENT_USER is
TYPE element_list IS TABLE OF NUMBER; 
function UpdateColCnsfileMetadata(root_name varchar2, new_groupname_gid varchar2, new_groupname_acl varchar2,repli_update_limit number default 0) return varchar2;
function GetGID(groupname varchar2) return number;
function GetAllDirectoriesUnder(root_fileid number) return element_list;
function GetAllFilesUnder(root_fileid number) return element_list;
function EncodeACLForDirectory( new_gid number, new_acl_gid number, fileid number) return varchar2;
function GetFileIDByTreeAddress(full_directory_path varchar2) return number;
function EncodeACLForFile( new_gid number, new_acl_gid number, fileid number) return varchar2;
function UpdateColCnsfileMetadataForDir(root_fileid number, new_gid number, new_gid_acl number,repli_update_limit number default 0) return varchar2;
function UpdateColCnsfileMetadataForFil(root_fileid number, new_gid number, new_gid_acl number,repli_update_limit number default 0) return varchar2;


end updatecnstab_pck;
/