Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
store pictures in Oracle and access it thru Visual Basic Help
- Thread starter LinaRaj
- Start date
Have a look in the Oracle8i Application Developer's Guide - Large Objects (LOBs):
You could use Oracle Objects for OLE (OO4O), a Windows-based product included with Oracle8i Client for Windows NT. You can make changes to a LOB via OO4O by using one of the following objects interfaces:
OraBlob: methods for performing operations on BLOB datatypes in the database
OraClob: methods for performing operations on CLOB datatypes in the database
OraBFile: methods for performing operations on BFILE data stored in operating system files.
Alternatively you might try invoking PL/SQL procedures from the DBMS_LOB package through ODBC.
You could use Oracle Objects for OLE (OO4O), a Windows-based product included with Oracle8i Client for Windows NT. You can make changes to a LOB via OO4O by using one of the following objects interfaces:
OraBlob: methods for performing operations on BLOB datatypes in the database
OraClob: methods for performing operations on CLOB datatypes in the database
OraBFile: methods for performing operations on BFILE data stored in operating system files.
Alternatively you might try invoking PL/SQL procedures from the DBMS_LOB package through ODBC.
- Status
Similar threads
- Locked
- Question