Skip to content
New issue

Have a question about this project? # for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “#”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? # to your account

BLOB limited to 32kB #471

Closed
maxsterlog opened this issue Dec 1, 2023 · 3 comments
Closed

BLOB limited to 32kB #471

maxsterlog opened this issue Dec 1, 2023 · 3 comments

Comments

@maxsterlog
Copy link

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
Copy link
Owner

sijms commented Dec 1, 2023

use url option lob fetch=post

@rondales
Copy link

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
Copy link
Owner

sijms commented Dec 30, 2023

use lob fetch=post in urlOptions

# for free to join this conversation on GitHub. Already have an account? # to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

3 participants