Oracle PL/SQL: Performance of CLOB data type in PL/SQL

Posted by drupalspring on Stack Overflow See other posts from Stack Overflow or by drupalspring
Published on 2010-04-14T07:25:17Z Indexed on 2010/05/30 1:12 UTC
Read the original article Hit count: 417

Filed under:

plsql

|

clob

If I use many CLOB variables in the PL/SQL stored procedure to store many long length string , are there any performance issues? Is the length of the CLOB is also variable? Are there any known limitations/disadvantages for CLOB instead using varchar2 and long?

© Stack Overflow or respective owner

Related posts about plsql

Iterating over files in PLSQL

as seen on Stack Overflow - Search for 'Stack Overflow'
Using a PLSQL script, is it possible to iterate over binary files in a folder and insert them as a BLOB in Oracle 10g? Any examples would be appreciated. >>> More
plsql show query

as seen on Stack Overflow - Search for 'Stack Overflow'
Hi all, I have a small problem using oracle pl sql. I have a sql file with some cursor, etc, and the treatement fail but with no details. I have an idea about the problem (a function with parameters) but I would like to see the parameter for each call, to be able to debug, to see exactly with wich… >>> More
Get 2 recoeds from PLSQL Cursor

as seen on Stack Overflow - Search for 'Stack Overflow'
Hi Guys... my Question is short, I create a cursor to get some values from my table I want to get the current record of cursor (the fetched record) and the next record from the cursor without fetching it, cause I want to make a calculation over the current record and the next record. in traditional… >>> More
Get two records from PLSQL cursor

as seen on Stack Overflow - Search for 'Stack Overflow'
My question is short. I create a cursor to get some values from my table. I want to get the current record of cursor (the fetched record) and the next record from the cursor without fetching it, because I want to make a calculation over the current record and the next record. In traditional programming… >>> More
PLSQL: How to go about it

as seen on Stack Overflow - Search for 'Stack Overflow'
I searched for this topic on SO but I did not found any recommendations and so am asking it as I am new to PLSQL and want to understand it: What is best way to get started with PLSQL ? What are best online resources or books available out there for understand PLSQL which you would recommend ? Do… >>> More

Related posts about clob

How to create a Clob in JPA in an implementation agnostic way

as seen on Stack Overflow - Search for 'Stack Overflow'
Hello I am using Ejb3 and JPA (based on Hibernate and Oracle 10g at the moment) I have an entity that contains a clob @Entity @Table(name = "My_TAB") public class ExampleEntity implements java.io.Serializable { private Clob someText; public void setSomeText(Clob someText) { this… >>> More
How do I copy a CLOB from Oracle into SQL Server

as seen on Stack Overflow - Search for 'Stack Overflow'
The CLOB is XML data that is 8k (sometimes 32k). Any suggestions? >>> More
CLOB WRITE WITH OO4O

as seen on Stack Overflow - Search for 'Stack Overflow'
I get the error : OIP-04908: This operation is not permitted on a Null LOB when Set MyClOB_0 = lOraDynaset_0.Fields("FILE_BODY").Value lOraDynaset_0.Edit amount_written = MyClOB_0.Write(buffer, chunksize, ORALOB_FIRST_PIECE) >>> More
Clob as param for PL/SQL Java Stored Procedure

as seen on Stack Overflow - Search for 'Stack Overflow'
I have a java stored procedure that takes in a clob representing a chunk of javascript and mins it. The structure of the function calling the JSP is as follows: function MIN_JS(pcl_js in clob) return clob as language java name 'JSMin.min(oracle.sql.CLOB) return oracle.sql.CLOB'; In the actual… >>> More
concatenate rows of Clob with plsql

as seen on Stack Overflow - Search for 'Stack Overflow'
Hi, late considere i conider if got a table who got an Id and a clob content like: create table v_EXAMPLE_L ( nip number, xmlcontent clob ); we insert our data: Insert into V_EXAMPLE_L (NIP,XMLCONTENT) values (17852,'delta548484646846484'); Insert into V_EXAMPLE_L (NIP… >>> More