tengo el siguiente llamado a un store procedure
Set conn = Server.CreateObject("ADODB.Connection")
conn.ConnectionTimeout = Application("ConnectionTimeout")
conn.CommandTimeout = Application("CommandTimeout")
conn.Open Application("ConnectionString"), Application("UserName"), Application("Password")
Set objCom = Server.CreateObject("ADODB.Command")
objCom.ActiveConnection = conn
objCom.CommandText = "Consult_status_enkeyword"
objCom.CommandType = adCmdStoredProc
'Parametros in, out
objCom.Parameters.Append objCom.CreateParameter("CEDULA", adVarChar,adParamInput,12,Session("USER"))
objCom.Parameters.Append objCom.CreateParameter("SYSTEMS", adVarChar,adParamInput,2,"01")
objCom.Parameters.Append objCom.CreateParameter("FECHA_EXPIRACION", adBoolean,adParamOutput)
objCom.Parameters.Append objCom.CreateParameter("HACER_PREGUNTA", adBoolean,adParamOutput)
objCom.Parameters.Append objCom.CreateParameter("CONTADOR", adNumeric,adParamOutput)
objCom.Parameters.Append objCom.CreateParameter("STATUS", adNumeric,adParamOutput)
objCom.Execute ME DA EL SGTE ERROR EN ESTA LINEA
ODBC driver does not support the requested properties.
el store procedure esta declarado asi
Consult_status_enkeyword(CEDULA in EN_KEYWORD.CED%type,
SYSTEMS in EN_KEYWORD.SOURCE_SYSTEM%type,
FECHA_EXPIRACION out BOOLEAN,
HACER_PREGUNTA out BOOLEAN,
CONTADOR out NUMBER,
STATUS OUT NUMBER) is
y los campos ced y source_system en la tabla son asi:
CED VARCHAR2(12) ,
SOURCE_SYSTEM VARCHAR2(2) ,
Gracias por la ayudaque puedan prestarme.
