Re: Calling Stored procedures from Oracle Forms 4.5

[Quoted] Forms 4.5 doesn't understand the concept of stored procedures.

You could try:

FORMS_DDL('madtest.madtest_proc(''TEST'')');

But don't expect to get an answer back.

Madhavan Amruthur <mad_at_sequent.com> wrote:

> 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

--
joebrown
_at_leading.net