Hi,
I apologize right from the beginning if this is the wrong place for putting my question (feedback welcome).
I have an Oracle 11R2 DB with characterset WE8MSWIN1252, and an oracle client 11R2 also with NLS_LANG german WE8MSWIN1252.
The db contains a function with string 'ÀÁÂÃÄÅÇÈÉÊËÌÍÎÏÐÑÒÓÔÕÖØŠÙÚÛÜÝŸŽàáâãåçèéêëìíîïðñòóôõøšùúûýÿž÷×þÞ¿¾½¼»º¹¸·¶µ´±¯®«ª©¨¥¤£¢¡™˜—–•”“’‘‹‰ˆ‡†…„ƒ‚~}|{`_^]\[@?;:/.-,+*)(&%$#"!' which is clearly not WE8MSWIN1252 (created with Toad for Oracle).
First, the function is created without problems and my first question is, does the character set of db matter for the PLSQL string constants?
Second, the function compiles and workes if invoked, the problem just arises when issuing a certain query (toad internal query, object search) containing the failing part
FROM SYS.ALL_SOURCE allsrc
WHERE REGEXP_LIKE(text, 'mysearchstring', 'i')
AND TYPE IN ('FUNCTION')
AND allsrc.owner IN ('MY_SCHEMA')
The query does not come to an end, the session process goes up to 100% CPU and killing the session is impossible unless killing the system process.
Does anyone have a clue if this is a bug, or if it is related to my first question?
Thank you very much for your feedback
Best
Martin