Skip to Main Content

Oracle Database Discussions

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!

"Long fetch" problem with BLOBs

372448Jul 8 2004
When I try to read BLOB fields from foreign database (Interbase) (in PL/SQL server code), I often got this error. After increasing HS_RPC_FETCH_SIZE and HS_LONG_PIECE_TRANSFER_SIZE it stops happening.

But in Forms when reading into Image item it still appears from time to time.

Any ideas what it depends from or how to solve this problem?
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Aug 5 2004
Added on Jul 8 2004
0 comments
399 views