Demonstration Schema and Code Examples

The code examples included in the online help and the example applications shipped with Oracle Objects for OLE are designed to work with a demonstration schema (database tables and other objects) and a demonstration user/password, scott/tiger.

Demonstration Schema Creation

You can create the OO4O demonstration schema with the script demobld7.sql located in the ORACLE_BASE\ORACLE_HOME\oo4o directory. You can drop the demonstration schema with the script demodrp7.sql.

Objects Referenced

The demonstration schema includes these objects:

· EMP and DEPT, demonstration tables.

· The user scott with password tiger (scott/tiger ), used for the Connect property.

If you want to use a different user/password, you must set up this user with the database objects that have been set up for scott/tiger.

· The network alias, ExampleDb, used for the DatabaseName property.

Refer to the Oracle Net Services Administrator's Guide for assistance in setting up the network service (database) alias and the tnsnames.ora file.

You can make changes to names of databases and names given to controls on a form, but you must be consistent through out the project. For example, you can rename the Oracle Data Control to MyDataControl, but be aware that all instances of ORADataControl must be changed to MyDataControl . You can also set up a network alias different than ExampleDb, but you must update all properties and code to reflect that change.

In many of the examples, you can access a local database using ‘‘‘‘ (a null string) for the network alias.

Related Files

The ORACLE_BASE\ORACLE_HOME\oo4o directory contains the following items:

· OO4O example programs. Subdirectories contain Visual Basic, ASP\IIS, C++, and Excel examples.

· The oraexamp.sql script, used to create stored procedures. Additional scripts, such as multicur.sql and empcur.sql, are provided to set up other example programs.

· The Oracle Objects for OLE Global Constant file, oraconst.txt, which contains constant values such as True and False (defined as the corresponding values in Visual Basic), and other constants used for option flags and property values.