Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

CLOB problems 1

Status
Not open for further replies.

vrudenko

Programmer
Feb 23, 2001
28
CA
Hi,

I have to create a procedure that takes a part of the CLOB as parameter to search CLOB in a table.

Can I and if it is possible how can I pass CLOB as parameter in a procedure?
How can I search CLOB using the pattern?

Thanks a lot for help in advance

Vira

 
If your CLOB's size is less then 32K you may write it by dbms_lob.write into varchar2 and make your pattern matching with varchar2, or if it's possible, split your lob into smaller varchar2 pieces and math them. You may also write some java procedure.
 
SEM ,

Thanks for your answer. I was helpful for me.

Vira
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top