Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

PL/SQL 303 ERROR (calling stored procedure throgh FORM)

Status
Not open for further replies.

shafiqm

Programmer
Sep 15, 2003
8
CA
Hi All,
I know that it is very simple in form to call any stored procedure. I created a package with lots of procedures in oracle7 for example mypackage, now i want to call one of the procedure in form (v4.5), lets suppose mypackage.myproc_1. But when i call the stored procedure through form, it gives me the PL/SQL 303 (qualifier <qualifer name> must be defined) error message. calling of same procedure is working fine in SQL*Plus. Is this a form version problem? If anyone of you come accross this situation please let me know how to resolve it.

Thanks in advance

 
Does the parameter have a default value defined in the procedure declaration, and if so is it missing from the form? In forms 4.5 you must supply all parameters for a procedure even if the parameteres are defaulted in the procedure.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top