Oracle Objects for OLE ORAINST.LOG... 4 Oracle Objects for OLE OO4O R LONG/LONG RAW BLOB CLOB B

Size: px

Start display at page:

Download "Oracle Objects for OLE ORAINST.LOG... 4 Oracle Objects for OLE OO4O R LONG/LONG RAW BLOB CLOB B"

ぜんぺいてらわ
5 years ago
Views:

1 Oracle Objects for OLE for Windows NT and Windows 95/ : J : Oracle Oracle Oracle Oracle Corporation JServer Oracle Call Interface Oracle Data Migration Assistant Oracle Database Configuration Assistant Oracle DBA Management Pack Oracle Enterprise Manager Oracle Forms Oracle intermedia Oracle Parallel Server Oracle Visual Information Retrieval Oracle7 Oracle8i PL/SQL Pro*C/C++ Pro*COBOL Pro*FORTRAN SQL*Plus Oracle Corporation Copyright 2000, Oracle Corporation All Right Reserved

2 Oracle Objects for OLE ORAINST.LOG... 4 Oracle Objects for OLE OO4O R LONG/LONG RAW BLOB CLOB BFILE C EMPMIX.EXE Oracle8 Assistant DLL JDBC Driver Oracle Objects for OLE for Windows NT and Windows 95/98

3 1. Windows NT 4.0 Windows 95 Windows 98 Intel PC MHz Pentium 3. 8 MB 16 MB 4. OO4O 10 MB 5. 10MB 6. OLE 32 Visual Basic 4.0/5.0/6.0 Excel 95/97 C++ 32 Microsoft Visual C++ 6.x 7. Net8 Client Oracle Oracle Objects for OLE Oracle Objects for OLE CD-ROM Oracle8 Enterprise Edition for Windows NT Oracle8 Workgroup Server for Windows NT CD-ROM 1. CD-ROM Oracle8 Products 2. Oracle Installer Oracle 3. * * Oracle Oracle 3

4 * Oracle Oracle * Oracle Japanese 4. OK Software Asset Manager OS Oracle Objects for OLE ORACLE 1 1 Windows 95 Oracle Objects for OLE MFC MFC42.DLL Oracle Objects for OLE MFC42.DLL Oracle Objects for OLE REGSVR32 %ORACLE_HOME% BIN ORADC.OCX %ORACLE_HOME% Oracle Objects for OLE Oracle ORAINST.LOG 1. Software Asset Manager 2. Installer OK Installer ORAINST.LOG 4 Oracle Objects for OLE for Windows NT and Windows 95/98

5 Oracle Objects for OLE OO4O R Oracle Objects for OLE Windows NT Windows 95 Windows 98 Microsoft Visual C++ 6.x C++ Oracle Windows NT Windows 95 Windows OLE Automation Server Microsoft MFC 6.x 32 Windows NT Windows 95 Windows Oracle.OCX OraDynaset GetRows Iterator OraCollection C++ OraDatabase OAQ OAQAgent OAQMsg OMetaData OMDAttribute Oracle Objects for OLE OO4O R

6 Microsoft Transaction Server MTS OLE Oracle8i OBlob OClob OBFile ORef Oracle8i - REF OObject OCollection VARRAY NESTED TABLE C++ Internet Information Server OO4O C++ %ORACLE_HOME% OO4O CPP WORKBOOK IIS %ORACLE_HOME% OO4O IIS Visual Basic %ORACLE_HOME% OO4O VB %ORACLE_HOME% OO4O CPP WORKBOOK CPP AQ LOB Metadata OBJECTS VARRAY 6 Oracle Objects for OLE for Windows NT and Windows 95/98

7 LONG/LONG RAW BLOB CLOB BFILE Oracle8i BLOB CLOB BFILE Oracle Objects for OLE LONG LONG RAW LONG RAW BLOB CLOB BFILE LONG RAW BLOB CLOB BFILE LONG LONG RAW BLOB CLOB BFILE AppendChunk AppendChunkByte GetChunk GetChunkByte GetChunkByteEx ReadChunk NULL BLOB CLOB Empty Chunk BLOB/CLOB/BFILE Read Write OO4O VB Visual Basic 6.0 OO4O OIP8.TLB OO4O ORADC.OCX ASP %ORACLE_HOME% oo4o Iis Samples ASP ConnPool Oracle Objects for OLE OO4O R

8 C++ ORACLM32.LIB ORACL.H ORACLM32.LIB empedt32 VC++6 VC++6 VC++6 %ORACLE_HOME% MSHELP - Oracle Objects for OLE %ORACLE_HOME% OO4O - SQL %ORACLE_HOME% OO4O CPP - DLL %ORACLE_HOME% OO4O CPP MFC - MFC Bound %ORACLE_HOME% OO4O EXCEL SAMPLES - Excel %ORACLE_HOME% OO4O VB SAMPLES - Visual Basic %ORACLE_HOME% OO4O VB SAMPLES QT - Visual Basic Quick Tour %ORACLE_HOME% OO4O IIS SAMPLES - IIS 8 Oracle Objects for OLE for Windows NT and Windows 95/98

9 Oracle ORADC.OCX MFC42.DLL Oracle Objects for OLE DOS regsvr32.exe oradc.ocx OCX Oracle In-Process Server Oracle Oracle IIS/ASP Oracle In-Process Server OraParameter OraParamArray RAW ORATYPE_RAW RAW 16 ORATYPE_RAW_BIN IN NULL OUT OUT 128 OraParameter MinimunSize OraParameters.AddTable OraParamArray ElementSize ORATYPE_RAW_BIN KB OraParamArray OraParamArray ORATYPE_RAW ORATYPE_RAW_BIN %ORACLE_HOME% OO4O VB SAMPLES RAW Oracle Objects for OLE OO4O R

10 OraAQ MonitorStart DCOM Win95 Win95 DCOM OLE32.DLL MFC42.dll regsvr32.exe %ORACLE_HOME% bin oip8.dll oradc.ocx NCHAR NVARCHAR2 ORA NCHAR NVARCHAR2 OO4O 2.3.x OO4O 2.3.x ORADYN_ORAMODE LOB ORADYN_ORAMODE LOB LOB Object REF OIP-4119: BLOB CLOB Object REF Visual Basic 6.0 : '5': VB 6.0 < > = & Visual Basic 6.0 Visual Basic 5.0 MsgBox "Ename:"& OraDynaset.Fields!ENAME MsgBox "Ename:"& OraDynaset.Fields("ENAME") 10 Oracle Objects for OLE for Windows NT and Windows 95/98

11 If OraDynaset.Fields!EMPNO = 7222 Then Msgbox "Hello World" If OraDynaset.Fields("EMPNO") = 7222 Then Msgbox "Hello World" Value "!" < > = & Msgbox VB5 VB6 MsgBox OraDynaset.Fields!ENAME MsgBox OraDynaset.Fields("ENAME") int_var = OraDynaset.Fields("EMPNO") Msgbox "Empno:"& int_var MS Knowledge Base Q194368:Operators Do Not Recursively Call Object Default Properties Windows 95 Windows 95 OO4O InProcServer32 ThreadingModel = "Both" NT OpenDatabase ORADB_NOWAIT 2.3 OraDynaset OraSqlStmt ExecuteSQL 2.3 OO4O R BeginTrans CommitTrans ExecuteSQL CreateSQL select... for update NOWAIT select... for update Oracle Objects for OLE OO4O R

12 LONG LONG RAW ChunkSize ChunkSize K GetChunk GetChunkByte GetChunkByte GetChunkByteEx ReadChunk MoveTo MoveRel Movexxxxn MoveTo: Row ID MoveFirst MoveTo ID MoveRel Movexxxxn: MoveNext MovePrev Find like DUAL VB VB Oracle DD-MON- YYYY 12 Oracle Objects for OLE for Windows NT and Windows 95/98

13 1 Oracle OO4O SQL TO_CHAR(date, fmt) SQL TO_DATE OIP VB NO_CACHE FindPrevious FindLast NoMatch TRUE ADD ADDTABLE ORAPARM_INPUT OUTPUT BOTH IOTYPE ORAPARM_INPUT IN ORAPARM_OUT OUT ORAPARM_BOTH IN OUT IN ORAPARM_BOTH ORAPARM_BOTH IN OUT IN OUT 2 Oracle Oracle Visual Basic OCX Microsoft VB OCX Oracle Microsoft VB Oracle Microsoft Visual Basic Sheridan Data Widgets Oracle Objects for OLE OO4O R

14 FarPoint Data Bound Grid Control VC++ Microsoft Visual Basic VB Edit Picture Image Oracle LONG RAW LONG RAW AppendChunk LONG RAW BLOB BLOB Microsoft OLE OLE VB 4.0 VB Microsoft Data Bound ORADC.UpdateRecord MoveNext MovePrevious Microsoft Data Bound ORADC.UpdateRecord MoveNext MovePrevious Microsoft Data Bound Data Control Recordset EOF BOF 14 Oracle Objects for OLE for Windows NT and Windows 95/98

15 ORADC1.Recordset BOF EOF BOF EOF TRUE EOF MoveFirst MoveLast BOF MoveLast MoveFirst Scroll DBGRID.Scroll Refresh DBGRID.Refresh ORADC.Recordset.Refresh [Del] 1 2 ORADC.Recordset.Delete MSGRID DBGRID.Bookmark Oracle Objects ORADC.Recordset.Bookmark DBGRID.Bookmark ORADC.Recordset.Bookmark OIP-4121 ORADC.Recordset.Bookmarks SelBookmarks Oracle MSGrid DBGrid1.Bookmark DBGrid1.Bookmark ORADC.Recordset.Bookmark ORADC.Recordset.Bookmark DBGrid1.Bookmark = DBGRID.SelBookmarks(0) ORADC.Recordset.Bookmark = DBGRID.SelBookmarks(0) MSGRID SelBookmarks ORADC.Recordset.Bookmark DBGRID.Bookmark ORADC.Recordset.Bookmark OIP-4121 SelBookmarks ORADC.Recordset.Bookmarks Oracle Objects for OLE OO4O R

16 Oracle MSGrid DBGrid1.Bookmark = DBGRID.SelBookmarks(0) (ORADC.Recordset.Bookmark =DBGRID.SelBookmarks(0) ) Sheridan Data Widgets Sheridan Data Bound OIP NULL Sheridan Sheridan Data Bound Sheridan Data Bound Recordset EOF BOF ORADC1.Recordset BOF EOF BOF EOF TRUE EOF MoveLast BOF MoveFirst 1 ORADC.Recordset.Delete 1 MovePrevious MoveNext Sheridan Oracle Objects for OLE for Windows NT and Windows 95/98

17 ORADC.Recordset.AddNew AddNew OIP-4118 MoveLast AddNew Sheridan 1 MoveLast Grid.MoveLast MoveLast ORADC.Recordset.MoveLast MoveRecords Refresh SSDBGRID1.Refresh ORADC.Recordset.Refresh Sheridan Enhanced FarPoint Data Bound : LONG RAW K LONG RAW Farpoint Spread Farpoint Farpoint MovePrevious MoveNext Oracle Objects for OLE OO4O R

18 Oracle RAW RAW C++ ODynaset: oresult GetFieldValue(int index, char *val, unsigned short maxlen, unsigned short *outlen) const; oresult GetFieldValue(const char *fieldname, char *val, unsigned short maxlen, unsigned short *outlen) const; oresult SetFieldValue(int index, const char *val, int len); oresult SetFieldValue(const char *fieldname, const char *val, int len); OField: oresult GetValue(const char **val, int *len) const; oresult SetValue(const char *val, int len); OParamArray: oresult GetValue(const char **val, int *len, int index) const; oresult SetValue(const char *val, int len, int index); OParameter: oresult GetValue(const char **val, int *len) const; oresult SetValue(const char *val, int len); OParameterCollection: OParameter Add(const char *name, const char *value, int len, int iotype, int servertype); %ORACLE_HOME% OO4O CPP WORKBOOK RAW ORACLM32.LIB C++ VC ORACLM32.LIB ApartmentThreaded OStartup C++ OSTARTUP_MULTITHREADED OStartup Oracle Objects for OLE for Windows NT and Windows 95/98

19 :CoInitializeEx() OLE32.DLL Win95 MultiThreading OStartup() NT 4.0 Windows 95 DCOM VC++ MFC42.DLL VC++ OIP MFC42.DLL IIS/ASP IIS 4.0 IIS 4.0 OO4O <OBJECT> <OBJECT RUNAT=Server SCOPE=Application ID=OraSession PROGID="OracleInProcServer.XOraSession"></OBJECT> Application("OraSession") OraSession SCOPE=Application global.asa <OBJECT RUNAT=Server SCOPE=Application ID=OraSession PROGID="OracleInProcServer.XOraSession"></OBJECT> <SCRIPT LANGUAGE=VBScript RUNAT=Server> Sub Application_OnStart End Sub Sub Application_OnEnd End Sub </SCRIPT> ASP LONG/LONG RAW ASP LONG/LONG RAW OraField GetChunkByteEx LOB Oracle Objects for OLE OO4O R

20 EMPMIX.EXE Norton AntiVirus EMPMIX.EXE Bloodhound.Unknown Oracle Installer EMPMIX.EXE Symantec Symantec AntiVirus Research Center AntiVirus Oracle8 Assistant 1. Oracle8 Assistant NT Administrators 2. Assistant / Net8 Assistant Net8 Easy Config Oracle INTYPE File Assistant 16 DLL xx805.dll DLL CD-ROM CD-ROM xxx805.dll DLL Oracle JDBC Driver Oracle JDBC Driver for JDK Oracle Objects for OLE for Windows NT and Windows 95/98

21 Oracle8i URL CD 21

22 22 Oracle Objects for OLE for Windows NT and Windows 95/98

Microsoft Word - J doc

Microsoft Word - J doc Oracle Objects for OLE for Windows 8.1.6.3.7 2000 5 : J01934-01 : : Oracle Windows Windows NT 4.0 Windows 2000 Windows 95 Windows 98 Windows NT Windows NT 4.0 Windows 2000 Oracle Objects for OLE R8.1.6.3.7