oracle8.1.6 select site_node.url(node_id) from site_nodes where object_id = :package_id begin :1 := pinds_blog_entry.new ( entry_id => :entry_id, package_id => :package_id, title => :title, content => :content, entry_date => to_date(:entry_date, 'YYYY-MM-DD'), draft_p => :draft_p, creation_user => :creation_user, creation_ip => :creation_ip ); end;