DevOps, CI/CD and Automation

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!

How to suppress 'Rep-0546 - Invalid parameter input' message in parameter form

272464May 15 2002

When user enters a non-numeric in a numeric parameter on parameter form, subject message is issued.
I want to supress the subject message as I am able to issue my own custom message thru SRW.MESSAGE(1,'Please enter a numeric value.')

I received suggestion from this forum that I should capture user input in a character type parameter, then use PL/SQL to validate and so on.

I tried this but when I issue RETURN(FALSE) at the end of PL/SQL, it again issues same message i.e 'Rep-0546 - Invalid parameter input'.

How can I prevent/suppress this.

Pl. guide.