Home » SQL & PL/SQL » SQL & PL/SQL » Re: How to Retrieve CLOB withADODB Command Parameter...?
Re: How to Retrieve CLOB withADODB Command Parameter...? [message #36845] Wed, 26 December 2001 12:55
aad2001
Messages: 1
Registered: December 2001
Junior Member
We were able to get this working using the following::

Dim Conn
set Conn = Server.CreateObject("ADODB.Connection")

Conn.Open "User ID=scott;Password=tiger;Data Source=db1;PLSQLRset=1;Provider=OraOLEDb.Oracle;"
...
..
..
Set prm = .CreateParameter(,adLongVarChar, adParamOutput, "100000")
.Parameters.Append prm
..
..

HTH.

----------------------------------------------------------------------
Previous Topic: problem!!!
Next Topic: PL/SQL Environment
Goto Forum:
  


Current Time: Mon Aug 03 05:07:47 CDT 2020