HELP: >32k Blob

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 Received on Wed Jul 05 1995 - 00:00:00 CEST