Re: Multiple value passing between forms

selina_at_dciem.dnd.ca (Selina Glynn) writes:
>One of my user wanted to select multiple values from a lookup table, and
>have the select values brought back to the calling field. I

If you mean a multi-row returned lookup, you will need to write your own using CALL_QUERY and global variables.

If you mean returning multiple-column values from one lookup, write your "list values SQL Text" like this:

   select col1, col2, col3 into :field1, :field2, :field3    from table1, table2 where table1.pk=table2.fk    order by col1, col2, col3

And so on...

>have asked oracle tech support, the person didn't know how to do it.

Sometimes the Oracle person hasn't had to answer a question like this, or may not have ever used the product prior to working for Oracle. Sigh. Always amuses and frustrates me when I know more about a product than the support person does.

-- 
Andrew Finkenstadt  |  Systems Analyst, Homes & Land Publishing Corporation
+1 904-575-0189     |  GEnie Sysop             ,,,
andy_at_genie.geis.com |                         (. .)     Peek-a-boo!
andy_at_homes.com      +----------------------o00-(_)-00o---------------------