How to test if a binding variable is null in PL/SQL?

Asked Dec 19 '21 at 17:29

Active Dec 19 '21 at 17:29

Viewed 29 times

I'm using ORDS to create a handler, and using PL/SQL to execute a script. The request should have in URL search params id.

When the id is supplied, everything works fine. But if the id is not supplied, I'd like to display a suitable error message.

Using IF :id = null or IF :id = '' doesn't seem to work. How should I do this properly?

Thanks!

asked Dec 19 '21 at 17:29

David Min

:bind_variable IS NULL – Pugzly Dec 19 '21 at 17:40
1

NULL is a special thing in SQL. We cannot test for it using the equality operator. Instead we need to use the IS operator as @Pugzly shows above – APC Dec 20 '21 at 16:47

0 Answers0