Which line in the above declaration would generate an error?

Examine the following DECLARE section of PL/SQL block:

Examine the following DECLARE section of PL/SQL block:

Which line in the above declaration would generate an error?

A.
Line 2

B.
Line 3

C.
Line 4

D.
Line 5

E.
Line 6

Show Hint

← Previous question

Next question →

Leave a Reply 18

Rose

answer: A

DECLARE
V_PP VARCHAR2 :=’TEMP’;
v_MM DATE:=SYSDATE;
V_BB DATE:= SYSDATE+10;
V_CC CONSTANT NUMBER(2):=2.23;
V_DD BOOLEAN NOT NULL DEFAULT TRUE;
BEGIN
NULL;
END;

Result
Error report –
ORA-06550: linha 2, coluna 6:

Explanation:
Error report –
ORA-06550: line 2, column 12:
PLS-00215: String length constraints must be in range (1 .. 32767)

Vladimir

piero

Burleson

Alisa

datatype: numeric(p,s)

Where p is a precision value; s is a scale value. For example, numeric(6,2) is a number that has 4 digits before the decimal and 2 digits after the decimal.

Jen

DECLARE
V_PA VARCHAR2 :=’a’; <== error, ORA-06550 String length must be in range (1 .. 32767)
V_PA VARCHAR2(1) :='abc'; <== error
V_PA VARCHAR2(5) :='abc';
V_DD BOOLEAN NOT NULL DEFAULT TRUE; <== fine
BEGIN
NULL;
END;