Re: Passing table from form to server and back

Chris Boyle wrote:
>
> Forms 6.0.5.32.0
> Oracle 8.1.6
>
> We have a form that generates an index-by table that needs further
> processing. When we pass that table to a procedure in the form it takes 3-5
> seconds but the same data can be processed on the server side in less then 1
> second. Is there a way to pass a table of data from a form to a server side
> process and back? The table is declared the exact same way in the form
> process as the server process but we keep getting an invalid type error
> message. Is this just a limitation of forms or can somebody suggest a
> workaround? I tried a search of the newsgroups with google and several
> manuals but did not find any solutions

Try the table on the Forms side being declared as a variable of type from the server side. ie if your server package is XXX, then the form pl/sql may contain something like:

local_var XXX.MY_TAB_TYPE

hth
connor

-- 
==============================
Connor McDonald

http://www.oracledba.co.uk

"Some days you're the pigeon, some days you're the statue..."