Troubleshoot ORA-00938: ORA-00939: not enough arguments & too many arguments for function

Reason:
This error is related to the oracle functions. For each and every function there should be well defined set of arguments. If you miss to specify the exact number of arguments, you will get these errors. In case if you are specifying less number of arguments you get ORA-00938: not enough arguments for the function and if you specify more number of arguments to a function you will get ORA-00939: too many arguments for function.
Please find some examples below with function substr.
Example:

SQL> select substr('Oracle database') from dual;
select substr('Oracle database') from dual
       *
ERROR at line 1:
ORA-00938: not enough arguments for function


SQL> select substr('Oracle database',3,3,3) from dual;
select substr('Oracle database',3,3,3) from dual
                                    *
ERROR at line 1:
ORA-00939: too many arguments for function

Substr function with proper syntax:
SQL> select substr('Oracle database',3,3) from dual;

SUB
---
acl
DBA Tips Data Pump Reference

0 comments:

Post a Comment

 

dba topics. Copyright 2011-16 All Rights Reserved | Site Map | Contact | Disclaimer | Google