passing CLOB parameter to Stored Procedure

Article View: borland.public.cppbuilder.database.ado

Article #993

Back to borland.public.cppbuilder.database.ado Previous Next

#993

From: Niyazi Unugur
Date: Tue, 23 Nov 2004 13:44

27 lines
1437 bytes

Hi,

Database is Oracle 9i

I have a stored procedure named SaveCLOBToDB(p_tablename varchar2, p_content clob)

Here is the code sample that is tried;

TFileStream *File;
...

TADOStoredProc *StoredProc;
char *Clob = new char [ File->Size ];

...

StoredProc->Parameters->CreateParameter("content", ftOraClob, pdInput, File->Size, Clob);


gives "Parameter object is improperly defined." 

How can i pass clob parameter to stored procedure?

i saw an example articel id 19504 borland developer network.

is it possible to use "returning p_content into :content" like syntax in stored procedure call?

Technical Details

Message-ID: <41a34ccb$1@newsgroups.borland.com>

Path:

arc1-ca.pugleaf.net!g2news1.google.com!news1.google.com!fu-berlin.de!newsfeed.iinet.net.au!newsfeed.iinet.net.au!PeerFeed.KWeb.on.ca!news.kweb.on.ca!newsgroups.borland.com!not-for-mail

Show Full Headers

Complete Article Headers

X-Google-Thread: 10698b,36ce5d94843f12c1,start
X-Google-Attributes: gid10698b,public
X-Google-Language: ENGLISH,ASCII-7-bit
From: "Niyazi Unugur" <unugurn@kentkart.com.tr>
Sender: "Niyazi Unugur" <unugurn@kentkart.com.tr>
Reply-To: "Niyazi Unugur" <unugurn@kentkart.com.tr>
Subject: passing CLOB parameter to Stored Procedure 
Newsgroups: borland.public.cppbuilder.database.ado
X-User-Info: 212.174.59.103     
NNTP-Posting-Host: 207.105.83.66
Message-ID: <41a34ccb$1@newsgroups.borland.com>
Date: 23 Nov 2004 06:44:27 -0700
X-Trace: newsgroups.borland.com 1101221067 207.105.83.66 (23 Nov 2004 06:44:27 -0700)
Lines: 28
Path: arc1-ca.pugleaf.net!g2news1.google.com!news1.google.com!fu-berlin.de!newsfeed.iinet.net.au!newsfeed.iinet.net.au!PeerFeed.KWeb.on.ca!news.kweb.on.ca!newsgroups.borland.com!not-for-mail