Re: Forms 3.0 and packaged procedures

dave_at_pdinsure.co.uk (David Broomfield) wrote:

> >Sorry, this isn't an answer. I do have a question tho. Are you
> >really able to (when all things work) call stored procedures
> >from forms 3.0? I was under the impression that was just
> >not possible. If indeed you are would you be willing to
> >enlighten me as to how you accomplish this?
> >
> >Thanks,
> >
> >
> >
> >
> >
> >
 

> The version of forms that we are using is 3.0.16.12.9. To call a
> packaged procedure/function you use the same syntax as you would from
> a normal PL/SQL block i.e.
 

> BEGIN
> package_name.procedure_name(.....);
> END;
 
> Oracle have bodged the version of PL/SQL that is bundled into forms
> (which is based on PL/SQL V1) to allow this to work. Up to a point it
> does, but there are these annoying tendencies to refuse to compile the
> form from time to time.

Many thanks for your response. We installed that 'patch' version of forms we had laying around (3.0.16.12.2) and things began to work. To say we are excited would be an understatement. Have not come across the need to flush the shared pool yet tho... Received on Wed Nov 22 1995 - 00:00:00 CET