oracle8.1.6
update acs_objects
set creation_user = :creation_user,
creation_ip = :creation_ip,
creation_date = sysdate,
context_id = :package_id
where object_id = :mp3_id
begin
:1 := mp3.new(
mp3_id => :mp3_id,
file_path => :client_filename,
title => :mp3_title,
$extra_vars
creation_user => :creation_user,
creation_ip => :creation_ip,
creation_date => sysdate,
context_id => :package_id
);
end;
update mp3_mp3s
set title = :mp3_title,
$extra_vars
deleted_p = 'f'
where mp3_id = :mp3_id