How to Retrieve CLOB with ADODB Command Parameter (StoredProc), NOT by a Select statement

Khodr

Hi everyone,

I am calling an Oracle StoredProc that returns a CLOB data type value as an
output parameter. What parameter data type should I use?

I tried adLongVarChar and adVarChar with the sizes 1000, 32000, 1000000 and they all fail. Size of returned value will exceed 50k. I know that there is a GetChunk, but I noticed that it applies only to SELECT statement. In my case, I have a StoredProc. I am using ADODB version 2.7
I am using VB.NET

if ADODB is not the right thing to use, so what is the right solution? and
how to use it?

Any help will be highly appreciated. Thanks.

Khodr

Nov 21 '05 #1

Subscribe Post Reply

4498

David Browne

"Khodr" <kh******@excite.com> wrote in message
news:OI****************@TK2MSFTNGP10.phx.gbl...

Hi everyone,

I am calling an Oracle StoredProc that returns a CLOB data type value as
an
output parameter. What parameter data type should I use?
I tried adLongVarChar and adVarChar with the sizes 1000, 32000, 1000000 and they all fail. Size of returned value will exceed 50k. I know that there is a GetChunk, but I noticed that it applies only to SELECT statement. In my case, I have a StoredProc. I am using ADODB version 2.7
I am using VB.NET

if ADODB is not the right thing to use, so what is the right solution?
and
how to use it?

ADODB is never the right thing to use. Use one of the oracle providers for
..NET.

here
http://www.oracle.com/technology/tec...net/index.html
you will find downloads and examples for CLOB and other oracle types.

David

Nov 21 '05 #2

Similar topics

ADODB Command parameter error !

by: Andre Azevedo | last post by:

Hi all ! I've created a .net serviced component with only one method. This method receive an ADODB.Command object and execute it. The ADODB.Command object is created in the client process. (VB...

C# / C Sharp

int casting error when trying to retrieve value from comboBox

by: Dica | last post by:

i can't seem to find a way to cast the value in my comboBox to integer. i've tried the following: short iProjectID = Convert.ToInt16(cboProjects.SelectedValue); i keep getting a "Sepcified...

C# / C Sharp

insert new record in Access dbase AND retrieve autonumber

by: loreille | last post by:

To insert a record in a Ms Access database and be able to retrieve the newly created ID (autonumber) I used the code below (code 1). Now, the problem is that this is not very secure and that, if...

ASP.NET

SQLDatasource/StoredProc/Dataview Update Command Q..

by: rob lynch | last post by:

I have been trying to get a grasp on how I can use a sqlserver storedproc as the UpdateCommand of a Dataview. The control (datview / SqlDatasource / Edit control) works great when you supply it...

ASP.NET

ADODB

by: Peter Newman | last post by:

Im still trying to get my head around this, but its the only way i have seen to be able to create a 'recordset' and bind text boxex to it and navigate throw each record by the click of a button ......

Visual Basic .NET

Clob as parameter in Java UDF

by: gimme_this_gimme_that | last post by:

I have the following Java code : package com.rhi.bb.udf.utils; import java.sql.Clob; import java.sql.SQLException; import java.util.regex.Pattern; import java.util.regex.Matcher;

DB2 Database

how to convert clob to other data type ?

by: t2581 | last post by:

Hi , I have database db2 udb 7.2 with following table and datatype CREATE DISTINCT TYPE APP.NOTEPAD AS SYSIBM .CLOB(4096); CREATE TABLE APP.AP_NOTE_PAD ( CONTROL_LOCATION INTEGER NOT NULL...

DB2 Database

GetSchema to retrieve column properties

by: Ken | last post by:

I'm trying to run a loop to capture column property information from a table in my datasource. Can anybody see where this is going wrong? Dim tbl As New DataTable Dim col As DataColumn Dim x...

Visual Basic .NET

Clob exception in DB2 CLP

by: Dsel | last post by:

Hi, I am trying to execute a stored procedure in DB2 Command Line Processor. Stored procedure is written in COBOL. It has 7 inputs and 3 outputs. The last output is CLOB of size 152000. This is...

DB2 Database

Access Europe meeting on Wed 2 August - An Access Developer Guide to creating applications in Blazor

by: isladogs | last post by:

The next Access Europe meeting will be on Wednesday 2 August 2023 starting at 18:00 UK time (6PM UTC+1) and finishing at about 19:15 (7.15PM) The start time is equivalent to 19:00 (7PM) in Central...

Microsoft Access / VBA

How to Use CodiumAI's pr-agent?

by: erikbower65 | last post by:

Using CodiumAI's pr-agent is simple and powerful. Follow these steps: 1. Install CodiumAI CLI: Ensure Node.js is installed, then run 'npm install -g codiumai' in the terminal. 2. Connect to...

General

Speedup your spring application

by: linyimin | last post by:

Spring Startup Analyzer generates an interactive Spring application startup report that lets you understand what contributes to the application startup time and helps to optimize it. Support for...

General

Steps manually installing IntelliJ IDEA.

by: erikbower65 | last post by:

Here's a concise step-by-step guide for manually installing IntelliJ IDEA: 1. Download: Visit the official JetBrains website and download the IntelliJ IDEA Community or Ultimate edition based on...

General

Development of Funny H5 Game - Toy Claw

by: kcodez | last post by:

As a H5 game development enthusiast, I recently wrote a very interesting little game - Toy Claw ((http://claw.kjeek.com/))。Here I will summarize and share the development experience here, and hope it...

HTML / CSS

Cancel Print Action if Sub form has No Records

by: DJRhino1175 | last post by:

When I run this code I get an error, its Run-time error# 424 Object required...This is my first attempt at doing something like this. I test the entire code and it worked until I added this - If...

Microsoft Access / VBA

Python code for finding the longest common subsequence

by: Rina0 | last post by:

I am looking for a Python code to find the longest common subsequence of two strings. I found this blog post that describes the length of longest common subsequence problem and provides a solution in...

Python

React to native button blinking effect

by: lllomh | last post by:

Define the method first this.state = { buttonBackgroundColor: 'green', isBlinking: false, // A new status is added to identify whether the button is blinking or not } autoStart=()=>{

Software Development

Windows 11 and Access Combo Box Issue

by: DJRhino | last post by:

Was curious if anyone else was having this same issue or not.... I was just Up/Down graded to windows 11 and now my access combo boxes are not acting right. With win 10 I could start typing...

Microsoft Access / VBA