BLOB Error in Oracle 11gR2
Posted: Thu 27 May 2010 15:46
I run the sample code as following:
ORA-06550: line 1, column 7:
PLS-00201:identifier 'DBMS_LOB' must be declared.
the code runs well in Oracle 10gR2, But when I switch to Oracle 11gR2, It pop-up a error message: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;
ORA-06550: line 1, column 7:
PLS-00201:identifier 'DBMS_LOB' must be declared.