Hi,
I am sort of new to working with blobs in plsql. I wrote a simple plsql stored procedure and am having problems compiling it. Here is the procedure
-----------------------------------
CREATE OR REPLACE PROCEDURE UPDATE_PDFS(v_PDF_NAME IN VARCHAR2, v_PDF_TYPE IN VARCHAR2, v_PDF IN BLOB)
AS

v_temp_PDF BLOB := EMPTY_BLOB();

BEGIN
v_temp_pdf := v_PDF;


IF v_PDF_TYPE = '8871' THEN
UPDATE TCC_INDEX_8871
SET PDF = v_temp_PDF
WHERE TCC_INDEX_8871.PDF_NAME = v_PDF_NAME;
ELSIF v_PDF_TYPE = '8872' THEN
UPDATE TCC_INDEX_8872
SET PDF = v_temp_PDF
WHERE TCC_INDEX_8872.PDF_NAME = v_PDF_NAME;
ELSIF v_PDF_TYPE = '990-' THEN
UPDATE TCC_INDEX_990
SET PDF = v_temp_PDF
WHERE TCC_INDEX_990.PDF_NAME = v_PDF_NAME;
END IF;

COMMIT;

END UPDATE_PDFS;
/
------------------

What's wrong with my procedure above? All I am trying to do is update a table with a blob. Are there any special ways to handle blobs in plsql? It compiles fine but the value of the v_temp_pdf is NULL.

Thanks