Re: OAS 4.0 and Oracle 8i refuse to execute stored procedures with more than 20 input parameters
From: Vladimir M. Zakharychev <bob_at_dpsp-yes.com>
Date: Wed, 5 Mar 2003 19:22:57 +0300
Message-ID: <b458ao$66g$1_at_babylon.agtel.net>
Date: Wed, 5 Mar 2003 19:22:57 +0300
Message-ID: <b458ao$66g$1_at_babylon.agtel.net>
Take a look at "Flexible Parameter Passing" in mod_plsql - sounds like a solution to your problem. With flexible parameter passing, you will receive two arrays - one with parameter names and one with parameter values. This way you are unlimited in number of actual parameters your procedure can accept, and it will not fail if any of them are missing, too.
By the way, 8.1.5 is long time desupported and is not recommended - move to at least 8.1.7.4.
-- Vladimir Zakharychev (bob_at_dpsp-yes.com) http://www.dpsp-yes.com Dynamic PSP(tm) - the first true RAD toolkit for Oracle-based internet applications. All opinions are mine and do not necessarily go in line with those of my employer. "Miquel Salvā" <msalva_at_3digits.es> wrote in message news:1046880289.557547_at_srv0...Received on Wed Mar 05 2003 - 17:22:57 CET
> Hi,
>
> I'm programming a web application with stored plsql procedures and Oracle
> Application Server.
>
> I started using Oracle 8.0.5 and OAS 4.0. It was working fine until I needed
> to use dynamic plsql and decided to upgrade to Oracle 8i (8.1.5).
>
> Some of my stored procedures have more than 20 input parameters and didn't
> supose any problem in the "old" instalation, but now when I try to execute
> them via OAS over Oracle 8i it returns an error as if the number of
> parameters I gave were incorrect.
>
> Modifying the procedure so it has less than 20 parameters works fine.
>
> In resume: with the same input form and the same stored procedure with more
> than 20 input parameters works under Oracle 8.0.5 but fails under 8i.
>
> Any ideas why the newest version doesn't accept more than 20 parameters?
>
> Thank you.
>
>
> Miquel Salvā
> msalva_at_3digits.es
>
>