I am attempting to upgrade to the latest 184.108.40.206 version of Ora Net Manager and 0040 from 220.127.116.11. We are running IIS on Win2003 connecting to Oracle 18.104.22.168 on Win2003.
Our DB connection string was like this:
Set db = CreateObject("OracleInProcServer.XOraSession"). _
OpenDatabase(DB_CONNECT, DB_ACCOUNT, 0)
now we have the default global.asa from 0040 and
set db = OraSession.getDatabaseFromPool(10)
Some of our ASP pages are generating this error on a second load.
Oracle Automation error '800a01b8'
OIP-04123: Duplicate parameter name, PARAM_ID
The error is caused by: db.Parameters.Add "PARAM_ID" not being removed properly.
1) Is there a way to tell IIS / ASP Parser to ignore these error that doesn't degrade the system? I know an On Error Resume Next may work, but seems to stall page loads.
2) Or, is there a way to loop through all db.Parameters and remove them?
I have unremoved parameters on about 1000 pages, so a simple routine to 'db.Parameters.Remove' all of them would save weeks of coding.
Thank you in advance for any advice.