Skip to Main Content

Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Boolean Parameter issue in utl_url.escape

SundasDec 31 2014 — edited Jan 5 2015

Hello,

   I am trying to use below query with 2nd parameter as TRUE but I'm getting below error.

select utl_url.escape(url => 'http://www.sample.com/ümlat.php&\^#q=name', escape_reserved_chars => TRUE) from dual;

Error:

[Error] Execution (16: 100): ORA-00904: "TRUE": invalid identifier

I should pass the parameter as TRUE ( default is FALSE)

Anyone can support me to over come from this issue.

FYI - I tried by creating a user defined function and it is working fine but I want to use directly in SELECT statement than using function.

This post has been answered by Roger Ford-Oracle on Dec 31 2014
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Feb 2 2015
Added on Dec 31 2014
2 comments
1,721 views