From mboxrd@z Thu Jan  1 00:00:00 1970
X-Spam-Checker-Version: SpamAssassin 3.4.5-pre1 (2020-06-20) on
	ip-172-31-74-118.ec2.internal
X-Spam-Level: 
X-Spam-Status: No, score=-1.9 required=3.0 tests=BAYES_00 autolearn=ham
	autolearn_force=no version=3.4.5-pre1
Path: eternal-september.org!reader02.eternal-september.org!aioe.org!5WHqCw2XxjHb2npjM9GYbw.user.gioia.aioe.org.POSTED!not-for-mail
From: "Dmitry A. Kazakov" <mailbox@dmitry-kazakov.de>
Newsgroups: comp.lang.ada
Subject: Re: converting pointer to value
Date: Fri, 5 Mar 2021 08:44:06 +0100
Organization: Aioe.org NNTP Server
Message-ID: <s1sng6$dek$1@gioia.aioe.org>
References: <s1r05i$d1$1@dont-email.me> <s1r33v$qsn$1@gioia.aioe.org>
 <s1sl9k$gdf$1@dont-email.me>
NNTP-Posting-Host: 5WHqCw2XxjHb2npjM9GYbw.user.gioia.aioe.org
Mime-Version: 1.0
Content-Type: text/plain; charset=windows-1252; format=flowed
Content-Transfer-Encoding: 8bit
X-Complaints-To: abuse@aioe.org
User-Agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:78.0) Gecko/20100101
 Thunderbird/78.8.0
Content-Language: en-US
X-Notice: Filtered by postfilter v. 0.9.2
Xref: reader02.eternal-september.org comp.lang.ada:61477
List-Id: <comp.lang.ada>

On 2021-03-05 08:06, Björn Lundin wrote:

> Anyway, some docs* I found describes Clob handling as

> use bind to bind nothing to the col - but tag it
> execute (will then return NEED_MORE_DATA)
> ParamData will return NEED_MORE_DATA and indicate what col that needs 

Yes, it returns in its buffer address + offset calculated as if 
parameters were an array. Here address is 1, if I remember correctly.

But you can just ignore that stuff as you know the column you write 
already. There is only one blob. If other parameters are bound normally 
or literals you just call PutData with the first chunk ignoring anything 
  but the return code of ParamData.

> the data (which is the problem i want to solve first)
> loop
>    putDAta
>    exit when put enough data
> loop
> final call to ParamData will now indicate SUCCESS.
> 
> 
> And I got that part to work to some extent. (if I putData in chunks of 
> 10 bytes and I said size= 100. But not if size = 104. Likely an error on 
> my part)

Did you specify 104 as the total size in BindParameter?

> And yes that small size is just me testing. chunks will be in larger 
> sizes when I get it to work.

It will be awfully slow, I guess.

-- 
Regards,
Dmitry A. Kazakov
http://www.dmitry-kazakov.de