SQL & PL/SQL

Hi,

Im trying to do this:

SELECT SUBSTR (''SELECT id DBMS_LOB.SUBSTR(cp.record, 3500)

  FROM USER1.CENTRAL_MONEY CM

WHERE ID = '''TYU456GGG''' AND

DBMS_LOB.SUBSTR (cm.record, 3500) like '''%KU%''',32,4);

So, I want to search a CLOB where ID = something and the CLOB contains KU. The query works fine WITHOUT SELECT SUBSTR. Because I want to select characters from position 32 of the DBMS_LOB.SUBSTR.

I get:

ORA-00907 missing right parenthesis

I cant see any missing parenthesis, can you guys?

Regards

LonelyDBA