Forum OpenACS Q&A: Scope

1: Scope
Posted by Anny Flores on
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?

2: Re: Scope (response to 1)
Posted by Rocael Hernández Rizzardini on
search for specific oracle errors on (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 ...

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
set new_relation_id [db_exec_plsql insert_person {
  :1 :=
    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
4: Re: Scope (response to 1)
Posted by Anny Flores on
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