Stored Procedures

From: Joni Pinomäki <joni.pinomaki_at_nokia.com>
Date: Mon, 06 Aug 2001 05:08:20 GMT
Message-ID: <8Dpb7.17764$cF.390259@news1.nokia.com>

Hi,

I have following problem:

I have to use a stores procedure to execute a query. I'm using oo4o and application is coded with asp. The error message is as follows

Oracle Automation error '800a01b8'

OIP-04122: Bind variable not fully enabled

I tried to define bind variables like
"OraDatabase.Parameters.Add "variable_name", value, ORAPARAM_INPUT OraDatabase.Parameters ("variable_name").ServerType = ORATYPE_VARCHAR2"

Is the syntax OK? Also how I have to define those VARCHAR2, BOOLEAN, DATE... I've been using an include file.

Thanks,

Joni Pinomäki Received on Mon Aug 06 2001 - 00:08:20 CDT