Questions tagged [clob]
Character Large Object - SQL data type used to store character strings longer than the regular CHAR and VARCHAR types allow.
clob
1,095
questions
0
votes
0
answers
25
views
Oracle Apex Display clob column as link to file
I have a grid in oracle Apex (22.1)
Select fin_id, fin_name,fin_details,fin_desc,fin_unit,fin_results;
FIN_ID->NUMBER
FIN_RESULTS->CLOB
Rest all are varchar2(100)
In grid the fin_results ...
0
votes
0
answers
7
views
HikariCP OracleDB PoolEntry, Clob objects Flush
I am using HikariCP and Oracle DB, in the HikariCP PoolEntry, T4CConnection has T4C8TTIClob objects cached in heap memory, how can we configure in Spring boot application to avoid caching or flushing ...
0
votes
0
answers
22
views
Not All Variables Bound
I have clob variable which is storing the sql statement to execute and I am assigning the sql output in table type object.
EXECUTE IMMEDIATE v_sql BULK COLLECT INTO result_table;
CREATE OR REPLACE ...
0
votes
0
answers
24
views
Using apex_export.download to download a clob as a csv file. I'm getting CLOB_COL "FILE_ID,BYTES,BLOCKS,STATUS
Apex version: 22.2.0
I have an apex application that allows a user to execute a query and then download the result as a csv. The result of the query is stored in a clob column in a table. My ...
0
votes
2
answers
76
views
XML transformation - duplicate node and concat string to existing tag values
Im new to xsltproc and want to transform this XML:
<services>
<event name="Something.zip">
<enabled>true</enabled>
<bindings>
&...
0
votes
0
answers
24
views
Getting oracle.SQL.CLOB@12c0350 when querying clob column in SQL
I have a XML response column in my database table. I am trying to use substr and instr functions to fetch only a particular string from the XML.
I have created a SQL query for this. For many rows, I ...
-1
votes
0
answers
37
views
Dapper Oracle and CLOB insert data argument was out of the range of valid values
When doing a Dapper Execute on an Oracle table with a CLOB data field and that value is over 1,900 characters I get this error:
System.ArgumentOutOfRangeException: Specified argument was out of the
...
0
votes
1
answer
52
views
MINUS operator not working with CLOB type column
I'm working in Oracle database and getting
ORA-00932: inconsistent datatypes: expected - got CLOB
error while using MINUS operator with a column of CLOB datatype.
Following is the query in which I'...
1
vote
1
answer
67
views
Compress selective rows in Oracle (19c)
I have a requirement to compress selective rows in Oracle. I wanted to see if it is possible.
So far I have read it is not possible (except workaround).
I cant do a CTAS. My table size is of 2 T.B.
...
0
votes
0
answers
67
views
Oracle. Procedures. Beginner. How to handle large string inputs? (CLOB)
I new to using Oracle, so I could really use the help.
I have a procedure:
create or replace procedure Demo_Name
(someId IN number default null,
planShapes IN string,
OutputCursor OUT ...
1
vote
0
answers
43
views
DBMS_XMLGEN.CONVERT fails only for clob with special character
I am using Oracle database 19.4 standard edition
This works
select DBMS_XMLGEN.CONVERT((chr(2)) ) from dual;
but when converting to clob it fails
select DBMS_XMLGEN.CONVERT(to_clob(chr(2)) ) from ...
0
votes
1
answer
105
views
Potential Risks of Using CLOB Instead of VARCHAR in Database for College Project?
I'm working on a college project where I need to store large paragraphs of text. I used a generative AI tool to generate some SQL code, and it suggests using CLOB instead of VARCHAR to handle the ...
0
votes
1
answer
89
views
Oracle SQL Loader for CLOB data type
Currently I am using oracleSQL Loader utility to load the data into the database. My CTL file is shown below. Here the column "LM_CAUTION_NOTE" data type is CLOB in the table. When I execute ...
0
votes
0
answers
28
views
How to pass a CLOB pramater to a PL/SQL procedure call in Python [duplicate]
I need to call my PLSQL procedure test_proc (parameter1 int ,parameter2 clob, paramter3 blob) inside python code as below.
if i execute below code , i am getting PLS-00306: wrong number of types of ...
0
votes
1
answer
234
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(...