Re: Calling Stored procedures from Oracle Forms 4.5

Madhavan,

    What is the size of your package? Try to reduce the size of your package so that it is <= 64K. I had the same problem, when I divided the package into smaller packages they worked fine.

    I think Oracle limits the size of the package to 64K.

Madhavan Amruthur wrote in message <3602D60B.BCA1E51_at_sequent.com>...
>Hi,
>I was trying to call a packaged procedure in Oracle Forms 4.5 trigger.
>The same procedure when executed from SQL plus works fine but when I try
>to conpile it in the trigger I get
>
>qualifier "madtest" must be declared.
>
>In SQL Plus exec madtest.madtest_proc('TEST') executes fine.
>In Forms trigger - does not and gives me the above error.
>
>any pointers would be greatly appreciated.
>Thanks in advance for your help.
>
>Thanks
>Madhavan
Received on Sun Sep 27 1998 - 06:35:05 CEST