Re: Using BLOBs through ODBC

"Alexander" <abauer_at_gmx.net> wrote in message news:3bbc2de9$0$21926$6e365a64_at_newsreader02.highway.telekom.at...
> OK, Oracle ODBC. But how to access the LOB-Fields, how to insert and
> retrieve data?
>
> Any source for ASP, vbscript,ADO???

Attached is a (slightly) edited copy of a function in use on one of our web sites. Sorry about the all Caps - it our developers standard way of distinguishing vb from javascript! As you can see just use the pl/sql package dbms_lob in your sql.

FUNCTION GET_DOCUMENT_DATA(ID,ITEM)
 SQLTEXT = "SELECT DBMS_LOB.GETLENGTH(DATA) LENGTH_OF_FILE,DOC_PATH FROM DOCS_DATA WHERE ID = " & ID & " AND ITEM = " & ITEM  SET RECORDSET = SERVER.CREATEOBJECT("ADODB.RECORDSET")  RECORDSET.CURSORLOCATION = 3
 RECORDSET.OPEN SQLTEXT,GLOBALCONN,3,1
END FUNCTION

--
Niall Litchfield
Oracle DBA
Audit Commission UK