We have a web (VBScript/ASP) application that uses RDS extensively to
access
an Oracle 9i database. It's been running fine for a couple of years but
now
LAN admins want to migrate it to another server. Mostly, it's running OK
-
makes ADO connections and successfully queries via ADO but RDS queries are
failing on ORA-24373 "Invalid length specified for statement".
Oracle doc says this message can occur when SQL issued to the database
equals zero, or exceeds the max. Since we get this with extremely short
SQL
statements - I suspect that what's happenning is that SQL are, for some
reason, getting truncated down to zero-length - before they get to Oracle.
We get the same result with valid SQL statements as well as valid ones.
Anybody run into anything like this before? Any suggestions as to how to
approach this prob. would be appreciated.
