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 (
p_file_id => :file_rev_id,
p_res_id => :res_id,
p_pathtofile => '__path_to_filename__',
p_filename => '__filename__',
p_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