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

Locked Post

New comments cannot be posted to this locked post.

Locked on Feb 2 2015

Added on Dec 31 2014

#database-key-features, #text

2 comments

1,721 views