Stored Procedures and SQL*FORMS

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;

(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 Tue Aug 10 1993 - 21:56:31 CEST