Forum OpenACS Q&A: Scope

Collapse
1: Scope
Posted by Anny Flores on 07/07/04 05:42 PM
Im using a procedure declared in a SQL package, when I try to execute the procedure with db_exec_plsql the next error massage appears:

PLS-00222: no function with name '<proc name>' exists in this scope

does any one know what am I doing wrong? could it be that de procedure is the problem or the way that Im using it?

Collapse
2: Re: Scope (response to 1)
Posted by Rocael Hernández Rizzardini on 07/07/04 07:03 PM
search for specific oracle errors on tahiti.oracle.com (free registration)....

seems that you are calling a proc that is not available for the given package (oracle pkg).... look if the proc name exists at all ...

Collapse
3: Re: Scope (response to 1)
Posted by Brian Fenton on 07/08/04 11:39 AM
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;
  }
]
Collapse
4: Re: Scope (response to 1)
Posted by Anny Flores on 07/09/04 06:32 PM
Hi, I solved my problem, but I dont know what was wrong in the code, I changed the name of the procedure, just that.

          Thanks Brian & Rocael