search

sijms / go-ora

Pure go oracle client
MIT License
771 stars 169 forks source link

BLOB limited to 32kB #471

Closed maxsterlog closed 8 months ago

maxsterlog commented 8 months ago

When retrieving a BLOB, the BLOB (blob.Data) retrieved is a maximum of 32kB, even though the BLOB in the database is significantly larger.

var blob go_ora.Blob
err = db.QueryRow("SELECT BLOBFIELD FROM TABLE WHERE ID = :id", sql.Named("id", id)).Scan(&blob)
sijms commented 8 months ago

use url option lob fetch=post

rondales commented 7 months ago

When retrieving a BLOB, the BLOB (blob.Data) retrieved is a maximum of 32kB, even though the BLOB in the database is significantly larger.

var blob go_ora.Blob
err = db.QueryRow("SELECT BLOBFIELD FROM TABLE WHERE ID = :id", sql.Named("id", id)).Scan(&blob)
sijms commented 7 months ago

use lob fetch=post in urlOptions