Environment:
Oracle 11.2.0.4 EE on Solaris
My customer has some program generated SQL that contains lots of bind variables, in some cases over 1000.
According to Oracle Support this has caused the creation of 'core' files to be generated based on the feedback from my SR on the subject.
So far they have been unable to tell me what the maximum number of bind variables that are allowed in a SQL statement.
I did read where the limit is 32767 in PL/SQL but these statements are straight SQL, again being generated from another program.
I have searched the Oracle Documentation but so far have been unable to come up with a number.
I would like to tell my customer to modify their SQL generation code to stay within the SQL limit for bind variables but I am unable until I know what that limit is. :-(
Thanks very much for any assistance!!
-gary