oracle8.1.6
select package_id
from apm_packages
where package_key='lorsm' and rownum = 1
select community_id
from dotlrn_communities_all
where rownum = 1
begin
:1 := ims_file.new (
file_id => :file_rev_id,
res_id => :res_id,
pathtofile => '__path_to_filename__',
filename => '__filename__',
hasmetadata => 'f'
);
end;
begin
:1 := content_item.get_root_folder(
item_id => :folder_id
);
end;
select format_id
from lorsm_course_presentation_fmts
where rownum = 1
select community_id
from dotlrn_communities_all
where rownum = 1