RE: "Too Many Declarations" Error

From: Igor Neyman <ineyman_at_perceptron.com>
Date: Thu, 27 Jan 2005 14:16:36 -0500
Message-ID: <004201c504a4$b8cb3540$2004a8c0@development.perceptron.com>

Kevin,

Could you post statements from the procedure, which use DECODE? It's not about number of DECODE calls.
Most probably, there is some type mismatch in expressions/values used as DECODE parameters.

Igor Neyman, OCP DBA
ineyman_at_perceptron.com

-----Original Message-----

From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Kevin Lange Sent: Thursday, January 27, 2005 2:06 PM To: oracle-l_at_freelists.org
Subject: "Too Many Declarations" Error

Evening guys;
  One of our developers keeps getting the following error when running a PL/SQL script on our 8.1.7.4 database under solaris 9:

SQL> @ongoing_facipsa_CALI_insert.sql

Warning: Procedure created with compilation errors.

Errors for PROCEDURE ONGOING2_CALI_FACIPSA_INSERT:

LINE/COL ERROR

---

---

37/14 PL/SQL: SQL Statement ignored
71/18 PLS-00307: too many declarations of 'DECODE' match this call

Does anyone know if there is an init-parm or something that drives how many
'too many' is that I can set differently ??

Thanks

Kevin

p.s. He is only using 2 decodes in that script ... so, why would this be
too many ?
--

http://www.freelists.org/webpage/oracle-l

--

http://www.freelists.org/webpage/oracle-l Received on Thu Jan 27 2005 - 14:19:08 CST