| 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.
----------------------------------------------------------------------
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
