Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> BLOB's in Web page
We're working to get a BLOB from our db into a web page via a stored
pl/sql procedure. How do we accomplish this? Right now we're
considering using a varchar2 as a pointer to the file. Here's a look
at our code using a file only (not using the DB):
procedure HOME
is
begin
htp.htmlopen; htp.headopen; htp.title('wise home page');
htp.p('<META HRRP-EQUIV="Expires" CONTENT="Mon, 12 Mar 2002 17:45:00 GMT">');
htp.p('</META>'); htp.headclose; htp.bodyopen; htp.header(1, 'EKBD'); htp.header(1, 'Welcome to WISE. Where you will Screechif you do not get
htp.tableOpen(cattributes => 'ALIGN ="center"'); htp.tableRowOpen; htp.tableData(htf.img2('owl.jpg', cattributes =>'height="259" width="259"'));
htp.tableRowClose; htp.tableClose; htp.bodyclose; htp.htmlclose;
We want to put the owl.jpg into the DB in a BLOB column, but how do we extract it? We're using 9i with all the develop software.
Any help would be appreciated. Please e-mail me: jascraig_at_hotmail.com.
Thanks,
Jason
Received on Tue Mar 12 2002 - 01:47:07 CST