Skip to main content

Questions tagged [clob]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
0 votes
0 answers
49 views

Calling stored procedures multiple times in the same transaction

I have a PLSQL Package with several stored procedures inside. This package is used to create specific reports. I call the procedures like that : package.init(parameter1 => 'Blablabla'); package....
Luke's user avatar
  • 1
0 votes
1 answer
174 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 ...
Faisal.softech's user avatar
0 votes
1 answer
1k 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, ...
Jefferson B. Elias's user avatar
0 votes
1 answer
3k 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 ...
R. Sluiter's user avatar
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 ...
Dallincha's user avatar
1 vote
1 answer
190 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 ...
user3102917's user avatar
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 ...
Geoff Dawdy's user avatar
  • 1,133
1 vote
1 answer
219 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 ...
Geoff Dawdy's user avatar
  • 1,133