Re: OWAREPL Upload.exe utility

Tom,

I checked the owai.c file and the bind type is set to 24. I changed the single quotes to double and it connected, but did not unload any of the images. Here is the output from the command shell.

D:\ORANT\OWS21\owarepl\src\unload>unload opca/opca_at_opca "select name, image from image" Attempting to logon with 'opca/opca_at_opca' Logged in as opca/opca_at_opca D:\ORANT\OWS21\owarepl\src\unload>

Also is there any way I can use a where clause to specify a specific image.

Thanks again,

Tom

Tom Creedon
High Performance Technologies inc
tcreedon_at_hpti.com
(703) 715-3466
--

On Tue, 28 Jul 1998 23:41:54 Thomas Kyte wrote:
>A copy of this was sent to tcreedon_at_my-dejanews.com
>(if that email address didn't require changing)
>On Tue, 28 Jul 1998 20:22:48 GMT, you wrote:
>
>>Tom,
>>
>>Thanks for the reply and sorry for the typo and confusion. I am trying to
>>unload images from the db to the filesystem. I have tried it as you suggested
>>and it keeps erroring out as if I am not supplying the proper number of args.
>>Also, would the fact that I compiled it using Oci80 affect it in any way.
>>
>
>Ok, say you are using the IMAGE table as I would create with the owarepl
>cartridge, the command line:
>
>C:\> unload joe/smoe_at_mydb "select name, image from image"
>
>
>should do it (DOS uses "parameter value" -- double quote -- to make a string a
>single parameter...)
>
>If not, cut and paste the error message and email me directly. I've used this
>with oci80 myself, no change in code.
>
>
>Oh, and I just noticed in my code that I have:
>
>
> /* if (odefin(&cda, 1, ucp, UCP_SIZE, 24, -1, */
> if (odefin(&cda, 1, ucp, UCP_SIZE, 8, -1,
> &indp, (text *) 0, 0, -1, &retl, &rcode))
>
>
>and
> for( fetched = 0, ret_len = 1; ret_len; fetched += ret_len )
> {
> if (oflng(&cda, 1, ucp, UCP_SIZE,
> /* 24, &ret_len, fetched )) */
> 8, &ret_len, fetched ))
> {
>
>If your source has that (in owai.c in src/unload) then I apologize. I
>occasionally use this to unload LONGS as well as long raws and I might have
>inadvertently posted a copy with the bind type set to 8 -- NOT 24 (8 is long,
24
>is long raw).
>
>If your owai.c in owarepl/src/unload has the above lines commented out and a
>similar line with 8 instead of 24 below it -- just change the 8 to 24 and
>rebuild....
>
>
>
>
>>Thanks again for you assitance,
>>
>>Tom
>>
>
>
>Thomas Kyte
>tkyte_at_us.oracle.com
>Oracle Government
>Herndon VA
>
>http://govt.us.oracle.com/ -- downloadable utilities
>
>----------------------------------------------------------------------------
>Opinions are mine and do not necessarily reflect those of Oracle Corporation
>
>Anti-Anti Spam Msg: if you want an answer emailed to you,
>you have to make it easy to get email to you. Any bounced
>email will be treated the same way i treat SPAM-- I delete it.
>

-----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/rg_mkgrp.xp Create Your Own Free Member Forum Received on Wed Jul 29 1998 - 09:53:37 CDT