Inserting a BLOB via OAS???

Hi everybody!

I'm trying to insert an image into a blob field in a table from browser using OAS 4.0.8.

So far what I've got is this:

CREATE OR REPLACE PROCEDURE Ins_Blob
(FILENAME VARCHAR2,
TESTFILE VARCHAR2) AS

BEGIN
INSERT INTO BLOBTEST
VALUES(FILENAME,EMPTY_BLOB());
COMMIT; UPDATE BLOBTEST
SET CONTENT = TESTFILE
WHERE NAME = FILENAME;

htp.htmlopen;
htp.bodyopen;
htp.print(' The following file has been added to the database:');
htp.br;
htp.print(FILENAME);
htp.bodyclose;
htp.htmlclose;

END; What I end up with is the following error on the update statement:

21/Apr/2000:14:07:52

ORA-01465: invalid hex number
ORA-06512: at "SCOTT.INS_BLOB", line 12
ORA-06512: at line 1

DAD name: WebDB
PROCEDURE : scott.ins_blob
USER : webdb
URL : http://test:80/webdb/scott.ins_blob? PARAMETERS :

Obviously, I'm not inserting the image into the table correctly, but for the life of me, I can't
seem to figure it out.

Can anybody help me????

Thanks in advance for all your help.

Joel

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Fri Apr 21 2000 - 00:00:00 CEST