All Questions
571
questions
0
votes
2
answers
47
views
ORA-22921: length of input buffer is smaller than amount requested
While I was working with a table containing a BLOB column:
SELECT id FROM table WHERE blob_column LIKE '%something%';
...I got the following error:
ORA-22835: Buffer too small for CLOB to CHAR or ...
1
vote
0
answers
32
views
Retrieving Latest BLOB (Excel File) for Power BI in Oracle
I hope you all are doing well. I have a question regarding working with BLOB data in Oracle and Power BI.
I have several Excel files stored as BLOBs within a table named GENERATED_FILES in my Oracle ...
2
votes
1
answer
72
views
How to efficiently store varying size byte arrays in an Oracle database?
I have an Oracle database table where I need to store byte array in one of the columns. The size distribution of these byte arrays is as follows:
80% are under 1000 bytes
15% are between 1000 and ...
1
vote
1
answer
72
views
Oracle SQL: most efficient way (in terms of network roundtrips) to do random little and scattered writes to a LOB column
I have a table with a BLOB column. Each BLOB can be up to 1GB in size. Updates of existing persistent BLOBs usually consist of thousands (~10k) of write microchunks at random offsets of around 100 ...
0
votes
1
answer
50
views
Oracle SQL and BLOBs: why do I need to lock the row of a BLOB am I modifying if I'm in a transaction anyway?
This question could reflect some misunderstanding from my part, but there's something that is puzzling me for days.
According to the Oracle docs (19c), it explicitly recommends to lock a row of a ...
0
votes
0
answers
54
views
Inferring Schema from Blob JSON Data in Spark SQL Query for Oracle Database
I have a JSON stored as a blob in an Oracle database. I need to read it with Spark, along with other fields from the table, using a Spark SQL query like:
SELECT id, request_timestamp, response FROM ...
0
votes
1
answer
239
views
Convert BASE64 to a BLOB in PL/SQL [duplicate]
I have this function
create or replace PACKAGE BODY UOM_UTIL_RENAMED AS
FUNCTION BASE64_TO_BLOB_(P_BASE64_CLOB CLOB)
RETURN BLOB IS
V_BLOB BLOB;
V_CHUNK_SIZE PLS_INTEGER := 24000;
V_CHUNK VARCHAR2(...
0
votes
1
answer
34
views
How to reduce the size of tif files before inserting into the oracle database
There are hundreds of tif files that have high volume
and I want to reduce their size before inserting to database.
How can I do? I tried the following function but file but
The file disappeared ...
0
votes
1
answer
96
views
how to extract points attribute in st_geometry object in oracle
I would like to extract shape data from a table. I can get entity,numpts,minx,miny all the attributes except POINTS which is is BLOB. I would like to get the data as varchar. How can I extract points ...
0
votes
0
answers
92
views
LZ_UNCOMPRESS inn. Oracle PL/SQL does not work as expected, unable to uncompress compressed data
The thing which I want to achieve is using Oracle Pl/sql stored procedure - I want to compress a blob data and put that in a json.
The structure will be like. -
{"Client_id" : "12345&...
0
votes
2
answers
29
views
Update BLOB column in table when > 4k
The situation is that a row is inserted into a table, and one of the columns is a BLOB. The BLOB is read from a file and works fine when inserting a new row. Here is the code used to perform the ...
1
vote
1
answer
140
views
The minimum size of Oracle LOB
As a beginner in PL/SQL I have a problem with understanding of the minimum size of Oracle LOBs. There is a lot of contradictory information in the Internet, including the official documentation of ...
1
vote
1
answer
131
views
Delphi BDE with connection to Oracle access violation
I'm searching for a bug in a big legacy product. The end user only reports a program crash (no error messages).
When I start the program with attached debugger I get this:
Im Projekt XXXXX.exe ist ...
0
votes
1
answer
224
views
Oracle DB. how to compress BLOB images columns preserving image type
I wish to extract, compress and upload some images stored into a BLOB DB column. I tried this approach
CREATE OR REPLACE procedure CompressImg (p_id in varchar2) as
v_blob_column blob;
begin
...
0
votes
0
answers
216
views
Reading blob data from Oracle database using C#
I need to read blob data from Oracle database and save it in a directory. I successfully convert blob data to byte array (byte[]) and I save it with
File.WriteAllBytes() method. When I want to open ...