Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

Sql with blob

2 views
Skip to first unread message

Manish

unread,
Aug 13, 2008, 3:02:56 PM8/13/08
to
Hi
I am using PB 11.1 and Oracle 10g

I have 2 sql statements
//Fails -- Doesn't return anything even though and i know it has atleast
more than 100 records

select count(*)
FROM table_1
where contains(rqst_tree_blob, 'lab', 6) > 0 ;

//Success
select count(*)
FROM table_2
where contains(rqst_tree_blob, 'lab', 3) > 0 ;

What am i doing wrong here?
TIA
manish

Bruce Armstrong [TeamSybase]

unread,
Aug 13, 2008, 4:49:42 PM8/13/08
to
What do you get when you issue the statements from SQL*Plus?

"Manish" <m...@hotmail.com> wrote in message
news:1nnorfll6d11o$.e4syh1wxr6kh$.dlg@40tude.net...

fisher

unread,
Aug 13, 2008, 5:22:57 PM8/13/08
to
To be honest I ain't sure Oracle Text is supported ...
It is about Oracle text contains operator isn't it ?


Manish :

Philip Salgannik

unread,
Aug 14, 2008, 10:47:02 AM8/14/08
to
If rqst_tree_blob is CLOB or smth like that, then AFAIK, you need to use
DBMS_LOB package functions...

"Manish" <m...@hotmail.com> wrote in message
news:1nnorfll6d11o$.e4syh1wxr6kh$.dlg@40tude.net...
0 new messages