Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: PLSQL- parameter questions

Re: PLSQL- parameter questions

From: John Thwaites <John.Thwaites_at_alliedsignal.com>
Date: Wed, 22 Jul 1998 16:27:26 -0400
Message-ID: <35B64B2E.E338D878@alliedsignal.com>


Try using a PL/SQL Table.

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:27:26 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US