Re: PLSQL- parameter questions

Try using a PL/SQL Table.

John Thwaites
AlliedSignal, Inc.
Polymers Division

GCooper wrote:

> Can't answer your ques from personal knowledge but you might try placing
> the data in a temp table and then you can drastically reduce the parameters
> to pass.
>
> --
> Greg Cooper
> 10032.1013_at_compuserve.com OR
> greg.j.cooper_at_corpmail.telstra.com.au
>
> Mark Aurit <mark_aurit_at_NOSPAM.mail.northgrum.com> wrote in article
> <35a5ae67.2890416_at_news.northgrum.com>...
> > I have an OWS application with roughly 50 discrete elements;
> > after gathering them I want to pass them to validation and update
> > stored procedures.
> > 1) is there a limit to the number of parameters you can pass (and
> > received)?
> > 2) obviously, passing 50 parameters from sp to sp is very messy. Is
> > there a cleaner data structure I should use?
> >
> > Thanks, Mark
> >
>
>
Received on Wed Jul 22 1998 - 15:28:11 CDT