ValueErrorEg - has been declared as VARCHAR2(5). */ declare...

Info iconThis preview shows page 1. Sign up to view the full content.

View Full Document Right Arrow Icon
Sheet1 Page 1 /* The VALUE_ERROR exception is raised in a number of situations related to truncation and conversion errors. For example, the following PL/SQL block attempts to assign the string More than 5 characters to a variable that
Background image of page 1
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: has been declared as VARCHAR2(5). */ declare xyz varchar2(5) begin dbms_output.enable xyz := 'More than 5 characters' exception when VALUE_ERROR then dbms_output.put_line('VALUE_ERROR raised') when OTHERS then NULL end /...
View Full Document

This note was uploaded on 07/15/2011 for the course ECO 2023 taught by Professor Mr.raza during the Summer '10 term at FAU.

Ask a homework question - tutors are online