Re: HELP: >32k Blob
Date: 1995/07/12
Message-ID: <3u10ok$j0m_at_epicycle.lm.com>#1/1
Morgan Skinner (morgan.skinner_at_fisons-ls.com) wrote:
> 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.
> UPDATEBLOB INVOICE
> SET STORED_COPY = :lbl_Invoice
> WHERE ID = :ld_Invoice
> USING ix_DB;
> COMMIT USING ix_DB;
> 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
Hi,
We faced this problem earlier, seems that PB 4.0 has a bug with respect to ORACLE blobs. You have to apply all 4.0.1 patches and then request for a special patch for pbor7040.dll.
This problem occurs for blobs between 32K to 64 K
HTH
Sridhar
Received on Wed Jul 12 1995 - 00:00:00 CEST