Questions tagged [clob]
The clob tag has no usage guidance.
7
questions
0
votes
1
answer
80
views
How to use CLOB datatype for storing limitless characters in column each rows?
I want to use CLOB datatype instead of varchar2(4000) and long, in which I want store limitless characters . However, its easy to declare the string based column to CLOB but the main problem is when I ...
0
votes
1
answer
988
views
UTL_HTTP call inside trigger leads to ORA-06502 when inserting from select [closed]
In order to allow a developer to make a SOAP call from an Oracle 11gR1 (11.1.0.7 PSU 24) instance using UTL_HTTP.
He created a stored procedure :
CREATE OR REPLACE PROCEDURE CALL_WS (URL IN VARCHAR2, ...
0
votes
1
answer
2k
views
inserting blob/clob over dblinks
I'm trying to find the best way to load a remote table with a blob column (blob only contains text, so clob would have been better).
So far we've been able to reduce loadtime from 218 minutes to 2 ...
1
vote
1
answer
4k
views
How to use GROUP BY on a CLOB Column
i'm trying to use this QUERY which contains a Clob Column (flow.IDFONCTIONNEL)
SELECT
flow.flowid,
min(flow.CONTEXTTIMESTAMP) contextTime,
flow.STATUT,
flow.IDFONCTIONNEL,
flow.ETAT
FROM Flux ...
- 15
1
vote
1
answer
149
views
Are LOBs also backed up if I take dump of all partitions of table individually?
I am taking export of a large table in oracle through datapump. I am taking export of all partitions one by one. The table has a LOB column as well. Are LOBs also backed up with partitions? Because ...
- 23
4
votes
1
answer
1k
views
How to migrate Unicode UTF-8 CLOB data from Oracle to SQL Server 2017 UTF-? [closed]
I am currently assisting in a migration effort of this application from Oracle 12c to SQL Server 2017. Initially I just performed table inserts using openquery to Oracle. I discovered that the tables ...
- 1,103
1
vote
1
answer
208
views
Migrating 2+ GB Oracle CLOB column to SQL Server VARCHAR(MAX)
I have a column on an Oracle db containing HTML data with embedded images that result in some records being over 2GB in size for that column. I have successfully migrated the rest of the database to ...
- 1,103