Thursday, January 29, 2009

SP2-0552: Bind variable "DBMS_OUTPUT" not declared.

DECLARE
v_weight NUMBER(3):=600;
v_message VARCHAR2(255):='Product 10012';
BEGIN
DECLARE
v_weight NUMBER(3):=1;
v_message VARCHAR2(255):='Product 11001';
v_new_locn VARCHAR2(50):='Europe';
BEGIN
v_weight:=v_weight+1;
v_new_locn:='Western'||v_new_locn;
DBMS_OUTPUT.PUT_LINE(v_weight);--2
DBMS_OUTPUT.PUT_LINE(v_new_locn);--Western Europe
END;
v_weight :=v_weight+1;
v_message:=v_message || 'is in stock';
v_new_locn:='Western'|| v_new_locn;
DBMS_OUTPUT.PUT_LINE(v_weight):--601
DBMS_OUTPUT.PUT_LINE(v_message);--Product 10012 is in stock
--DBMS_OUTPUT.PUT_LINE(v_new_locn);
END;
/

SP2-0552: Bind variable "DBMS_OUTPUT" not declared.



DECLARE
v_name VARCHAR2(10) :='Oracle';
BEGIN
DBMS_OUTPUT.PUT_LINE(v_name);
END;
/

PL/SQL procedure successfully completed.

Oracle


Solution
DBMS_OUTPUT.PUT_LINE(v_weight):--601
colon added