What rules apply to escaping a pattern in dbms_lob.instr?
jtp51Mar 16 2009 — edited Mar 16 2009From [http://download.oracle.com/docs/cd/B19306_01/appdev.102/b14258/d_lob.htm#i998546]
{color:#0000ff}DBMS_LOB.INSTR (
lob_loc IN CLOB CHARACTER SET ANY_CS,
pattern IN VARCHAR2 CHARACTER SET lob_loc%CHARSET,
offset IN INTEGER := 1,
nth IN INTEGER := 1)
RETURN INTEGER;{color}
If I pass in a value of 'Hello', there is no problems returning the integer value, but if I try to search for a url that starts with 'http://', then 0 is returned. I've been searching the 10.2.0 and I don't have access to 10.2.0/rdms/demo, what rules apply to escaping a pattern in dbms_lob.instr?
I've tried backslash and quotes, neither has worked at this point...