Hi
I must to do a procedure in the vb that call a Stored procedure in Oracle, but inside oracle a of the parameters is type LONG and can not to change type of procedure.
I must do send a HTML code in the parameter , I tried code below

Code:
...
...
Set param3 = cmd.CreateParameter("P_DS_CORPO", adChar, adParamInput, 10000)
  cmd.Parameters.Append param3
  param3.Value = mensagem
...
..
When parameter mensagem is only text work fine. The Stored Procedure work fine with other applications, other stored procedures or applications (no vb) call and work fine, I changed adchar by adLongVarChar and too no worked