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: GCooper <100032.1013_at_compuserve.com>
Date: Sat, 18 Jul 1998 05:28:42 -0400
Message-ID: <01bdb22e$b54b1b80$08208a90@greg>


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 Sat Jul 18 1998 - 04:28:42 CDT

Original text of this message

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