Skip to Main Content

SQL & PL/SQL

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 can we check whether any value has been passed to string variable or not

Jaismeen-OracleFeb 23 2017 — edited Feb 27 2017

Hi All,

I haveĀ  a input variable where user can give values like 'java1','java2','java3' or 'java1' or they can even leave it blank.

Can someone please let me know whether its possible to check whether the user has given any value to this variable or not because I tried using is not null but got the below error when input variable was passed as 'java_2','java_3'

ORA-06550: line 12, column 4:

PLS-00306: wrong number or types of arguments in call to 'IS NOT NULL'

ORA-06550: line 12, column 1:

PL/SQL: Statement ignored

Is it possible to know whether any value has been passed to it or not .

Thanks in advance

This post has been answered by Jarkko Turpeinen on Feb 23 2017
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Mar 27 2017
Added on Feb 23 2017
9 comments
773 views