Oracle PL[s]SQL by Example

In order to test your progress, you should be able to answer the following questions.

1)

The SQLCODE function returns an Oracle error number.

  1. _____ True

  2. _____ False

2)

The SQLERRM function returns the error text corresponding to a specific error number.

  1. _____ True

  2. _____ False

3)

When the SQLERRM function cannot return an error message corresponding to a particular error number, which of the following occurs?

  1. _____ SQLERRM causes an error.

  2. _____ SQLERRM does not return anything.

  3. _____ SQLERRM returns "non-ORACLE exception" message.

4)

What is the maximum length of the error text returned by the SQLERRM function?

  1. _____ 450 bytes

  2. _____ 550 bytes

  3. _____ 512 bytes

5)

The SQLCODE function always returns a negative number.

  1. _____ True

  2. _____ False

Answers appear in Appendix A, Section 11.3 .

Категории