<?xml version="1.0"?>
<queryset>
   <rdbms><type>oracle</type><version>8.1.6</version></rdbms>

<fullquery name="fix_creation">      
      <querytext>
      
update acs_objects
set    creation_user = :creation_user,
       creation_ip = :creation_ip,
       creation_date = sysdate,
       context_id = :package_id
where object_id = :mp3_id
      </querytext>
</fullquery>

 
<fullquery name="add_mp3">      
      <querytext>
      
begin
   :1 := mp3.new(
      file_path => :client_filename,
      $extra_vars
      creation_user => :creation_user,
      creation_ip => :creation_ip,
      creation_date => sysdate,
      context_id => :package_id
      );
end;

      </querytext>
</fullquery>


<fullquery name="update_mp3_info">      
      <querytext>


      </querytext>
</fullquery>


</queryset>