Skip to Main Content

DevOps, CI/CD and Automation

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

OEDB ASP returning output params ploblem

420335Apr 30 2004 — edited Apr 30 2004
I am trying to return output params with my stored proc.
The code used to work when I used a DSN version for the connection string.
I had to change to use OLEDB as the procs return cursors.

Since I changed I can no longer get access to OUT parameters.
The commented out version is the original. There are no cursors in this example, but the problem is the same. I dont want to use differen conn strings depending.

'connection strings
Application("oracle_connection") = "Provider=OraOleDb.Oracle;Data Source=TLS;User ID=TIMSS;Password=TIMSS"
'Application("oracle_connection_dsn") = "DSN=TLSWINDEV1;Uid=timss;Pwd=timss"

'strSQL = "IASB_WEB_UTILS.UsereMailCheck"
strSQL = "{call IASB_WEB_UTILS.UsereMailCheck(?,?,?)}"
Set command = Server.CreateObject("ADODB.Command")
Set command.ActiveConnection = conn
command.CommandText = strSQL
'command.CommandType = 4
command.CommandType = 1

command.Parameters.Append command.CreateParameter("email_address",200, 1, 255, email)
command.Parameters.Append command.CreateParameter("email_found",200, 2, 255)
command.Parameters.Append command.CreateParameter("errorcode_o",3, 2)

command.Execute()
iErrorCode = ""&command.Parameters.Item("errorcode_o").value
strEmailFound = Trim(LCase(command.Parameters.Item("email_found").value))
strEmailFound = left(strEmailFound, instr(strEmailFound,chr(0))-1)

strEmailFound used to return failure or success. Now with the OLEDB version the left() function fails. This happens with all the procs not just this one.

Note:
The left is required since I have to specify the length for the email_found and some kind of padding happens on the returned variable (under ODBC) to fill upto the specified number of chars e.g. 255 in this case.
E.g. Len(command.Parameters.Item("email_found").value) = 256 by default
Database version: Oracle8i Enterprise Edition Release 8.1.7.0.0
OLEDB version Oracle Provider for OLE DB 8.1.7.0.0

Is this a bug?
Is it possible to upgrade the OLEDB library?
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on May 28 2004
Added on Apr 30 2004
1 comment
618 views