BLOB Error in Oracle 11gR2

[3dhunter]

I run the sample code as following:

CREATE OR REPLACE
PROCEDURE ClobTableUpdate (p_Id IN NUMBER, p_Name IN VARCHAR2,
p_Desc IN CLOB)
IS
BEGIN0
UPDATE ClobTable
SET
Name = p_Name,
Desc = p_Desc
WHERE
Id = p_Id;
END;
the following code can be used:
OraStroredProc.Options.TemporaryLobUpdate := True;
OraStroredProc.StoredProcName := 'ClobTableUpdate';
OraStroredProc.Prepare;
OraStroredProc.ParamByName('p_Id').AsInteger := Id;
OraStroredProc.ParamByName('p_Name').AsString := Name;
OraStroredProc.ParamByName('Desc').ParamType := ptInput;
OraStroredProc.ParamByName('Desc').AsOraClob.LoadFromFile(FileName);
OraStroredProc.Execute;

the code runs well in Oracle 10gR2, But when I switch to Oracle 11gR2, It pop-up a error message:
ORA-06550: line 1, column 7:
PLS-00201:identifier 'DBMS_LOB' must be declared.

[bork]

Hello

The problem is that package 'DBMS_LOB' at your Oracle 11gR2 server was not installed or was damaged. You should appeal to Oracle administrator in your company to resolve this issue.