Stored Procedure from Form

I seem to be having some kind of privilege problem calling a stored procedure within a package from a form (v3). The form generates fine when I connect as app_owner, but not from my development account. I am using a public synonym to reference the package in the form, and EXECUTE on the package has been granted to PUBLIC.

Simplified:

 CREATE PACKAGE app_owner.mypackage AS
  PROCEDURE myprocedure (arg1 app_owner.table1.column1%TYPE)   PROCEDURE simpleprocedure ;
 END mypackage;

 CREATE PACKAGE BODY app_owner.mypackage AS   PROCEDURE myprocedure (arg1 app_owner.table1.column1%TYPE) AS

  BEGIN
    NULL;
  END myprocedure ;

  PROCEDURE simpleprocedure AS
  BEGIN
    NULL ;
  END simpleprocedure ;

 CREATE PUBLIC SYNONYM mypackage_syn FOR app_owner.mypackage ;

 GRANT EXECUTE ON app_owner.mypackage TO PUBLIC ;

Then, in the PRE-INSERT trigger of a form, I try to call the procedure using the following syntax:

  MYPACKAGE_SYN.SIMPLEPROCEDURE ; When I try to compile this trigger, I will get these errors:

  Qualifier 'table1' must be declared

and

  Qualifier 'mypackage_syn' must be declared

I am scouring over the Application Developer's Guide, but haven't been able to find anything yet. Am I missing something simple? Can anyone suggest what I might be doing wrong? Thanks...Steve   Received on Thu Jun 29 1995 - 00:00:00 CEST