View the Exhibit and examine the structure of the SALGRADE table.
Examine the following code:
What is the outcome?
A.
It is created successfully.
B.
It gives an error because the return clause condition is invalid.
C.
It gives an error because the usage of the host variables is invalid.
D.
It gives an error because the data type of the return clause is invalid.
Explanation:
c
bind variables are not used correctly..
the answer is C
sqlplus output:
SQL> show errors
Errors for FUNCTION SAL_OK:
LINE/COL ERROR
——– —————————————
4/26 PLS-00049: bad bind variable ‘MIN_SAL’
4/36 PLS-00049: bad bind variable ‘MAX_SAL’
The answer is c
Error(4,53): PLS-00049: bad bind variable ‘MAX_SAL’
C
C
C
??