ODP.NET

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

STORED PROCEDURE + OUTPUT PARAMETER + BLOB + BIG BLOB = PROBLEM

285711Nov 15 2004 — edited Nov 15 2004

Hi,

I'm trying to use ODP.NET to retrieve a BLOB. I want to retrieve the BLOB using an output parameter of a Stored Procedure (not a Function). (that works fine with little-sized BLOB's)

The problem is with large BLOB's. ( > 200.000 or 300.000 bytes)

Can anyone send a sample? (doesn't matter the schema, the language, .... only looking for a working sample).

There is any method to do this with a Stored Procedure?

My database is Oracle 9.2, and I can use ODPv9 or ODPv10.

Thanks in advance.

Felix.

Locked Post

New comments cannot be posted to this locked post.

Locked on Dec 13 2004

Added on Nov 15 2004

#odp-net

1 comment

2,747 views