Forum OpenACS Q&A: Re: Scope

Collapse
3: Re: Scope (response to 1)
Posted by Brian Fenton on
Hi Anny, try calling your procedure by prefixing the package name like I've done here with user_pkg.new:
set new_relation_id [db_exec_plsql insert_person {
  begin
  :1 := user_pkg.new(
    creation_user        => :user_last_changed,
    creation_ip          => :user_ip,
    first_names          => :first_names,
    last_name          => :last_name,
    date_of_birth           => :date_of_birth_date,
    default_minor_p        => :default_minor_p,
    user_last_changed      => :user_last_changed
  );
  end;
  }
]