Home » SQL & PL/SQL » SQL & PL/SQL » Working with CLOB
Working with CLOB [message #247394] Mon, 25 June 2007 14:44 Go to next message
manisinghus
Messages: 1
Registered: June 2007
Location: India
Junior Member
Hi All,
I am working with CLOB and facing one issue. There is a table which has a column of varchar2(4000) and we have reached to limit of 4000 characters. So we changed that to CLOB. Now if I use the SQL statement through application they are working fine. But I have one stored procedure which has a ref cursor in it, which is taking huge time to execute and if the same query is executed through vb application it runs very fast. In the stored procedure the CLOB column was used in Where condition with LIKE clause, so we replaced LIKE clause with dbms_lob.INSTR function and there is a slight improvement. Please suggests some option to improve this SP execution.

Thanks in Advance.

Mani
Re: Working with CLOB [message #247399 is a reply to message #247394] Mon, 25 June 2007 14:54 Go to previous messageGo to next message
Michel Cadot
Messages: 64133
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Not enough information.
No Oracle version.
No help.

Regards
Michel
Re: Working with CLOB [message #247418 is a reply to message #247394] Mon, 25 June 2007 17:35 Go to previous messageGo to next message
toyway
Messages: 32
Registered: July 2002
Member
Why don't you use Oracle Text to speed up your queries against CLOB?

~ Oleg
Re: Working with CLOB [message #247481 is a reply to message #247418] Tue, 26 June 2007 01:31 Go to previous message
Maaher
Messages: 7062
Registered: December 2001
Senior Member
toyway wrote on Tue, 26 June 2007 00:35
Why don't you use Oracle Text to speed up your queries against CLOB?

~ Oleg

Good point!

MHE
Previous Topic: PL/SQL: READ UTL_FILE using separator
Next Topic: How to print message like :no of rows are deleted from emp"
Goto Forum:
  


Current Time: Thu Dec 08 04:18:50 CST 2016

Total time taken to generate the page: 0.05539 seconds