Re: Stored Procedures and SQL*FORMS

In article <248uhf$ebi_at_sun1.clark.net>, rono_at_clark.net (Ron Olshavsky) writes:
> Hey Net*Folk,
>
> Can anyone tell me if it is possible to create a stored procedure
> that contains form-type commands (ie, HOST and CALL,CALL_QUERY) and access
> this procedure from a form?? Ive tried, but cant seem to get the procedure
> to compile and store correctly...
>
> My test case was something simple like:
>
>
> create procedure file_manager as
> begin
> new_form('file_man');
> end;
>

HATE TO TELL YOU THIS, BUT I JUST WROTE A TEST FORM EXACTLY AS ABOVE AND IT CALLED THE NEW FORM CORRECTLY. NO PROBLEMS. YOU ARE INCLUDING AN APPROPRIATE CALL TO THE PROCEDURE? IE, IN A KEY-NXTFLD TRIGGER INCLUDE THE LINE         FILE_MANAGER;
>
> (Does a whole lot huh) :)
>
> This is not what the procedure will do, but rather just a test to see if
> we can use these types of commands in a stored procedure, or if they are
> restricted to 'straight' sql or PL/SQL commands without the FORMS extensions.
>
> Thanks for any info
> Ron
>
> rono_at_clark.net
Received on Wed Aug 11 1993 - 23:26:17 CEST