Re: HELP: >32k Blob

In article <3teqi8$jjd_at_alterdial.UU.NET>, morgan.skinner_at_fisons-ls.com says...
>
>Hi,
>
>I am having trouble storing a blob from PowerBuilder into an Oracle
>7.1 database that is > 32k - when I read the blob back from the
>database I only get 32,765 bytes.
>
>The syntax is...
>
> UPDATEBLOB INVOICE
> SET STORED_COPY = :lbl_Invoice
> WHERE ID = :ld_Invoice
> USING ix_DB;
> COMMIT USING ix_DB;
>
>And to retrieve the blob...
>
> SELECTBLOB STORED_COPY
> INTO :lbl_Invoice
> FROM INVOICE
> WHERE (ID = :ld_Invoice)
> USING ix_DB;
>
>Any ideas what I am doing wrong?.
>
>TIA!
>
>--------------------------------------------------------
>
>I was the Englishman in PM122 & PM123 with the Questions
>
>email : morgan.skinner_at_fisons-ls.com
>

-- 
Oracle can store more than 32KB BLOBs. I think it is up to 1GB. Make sure that lbl_invoice
was changed to BLOB data type. For example

BLOB	lbl_invoice

lbl_invoice = blob("enter you text")


______________________________
Ahmad Ghosheh                 |
Analysts International. Corp. |
Kansas City, MO               |
USA                           |
                              |
aghosheh_at_databank.com         |
______________________________|