Main Tables Views Indexes Constraints Triggers Procedures Functions Packages Sanity check Index

ACS3 Data Model

Arguments Source

HP_GET_FILESYSTEM_CHILD_COUNT

Arguments:

NameData TypeDefault ValueIn/Out
FSIDINTEGER(38.0) IN

Returns:

INTEGER(38.0)

Source

Source
     1: function hp_get_filesystem_child_count (fsid IN integer)
     2: return integer
     3: IS
     4: 	CURSOR count_cursor IS
     5: 		select count(*) from users_files
     6: 		where parent_id=fsid;
     7: 	counter		integer;
     8: BEGIN
     9: 	OPEN count_cursor;
    10: 	FETCH count_cursor INTO counter;
    11: 	CLOSE count_cursor;
    12: 	return counter;
    13: END;


Generated by OraSchemaDoc, (c) Aram Kananov, 2002