📄 readme.html
字号:
<!doctype html public "-//w3c//dtd html 4.0 transitional//en">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<meta name="Author" content="Reghu">
<meta name="GENERATOR" content="Mozilla/4.7 [en] (WinNT; I) [Netscape]">
<title>ReadMe</title>
</head>
<body>
<h1>
<b><u><font face="Arial,Helvetica"><font color="#000099">Returning Multiple
Recordsets And Passing NLS</font></font></u></b></h1>
<h1>
<b><u><font face="Arial,Helvetica"><font color="#000099">Data To A Stored
Procedure</font></font></u></b></h1>
Contents of this document
<p> <a href="#1.Overview of the Sample">Overview
of the sample</a>
<br> <a href="#2.Software Requirements">Required
Software</a>
<br> <a href="#Assumptions">Assumptions</a>
<br> <a href="#Description of Files in the sample">Description
of files in the sample</a>
<br> <a href="#5. Prepare and Run the Sample">Prepare
and Run the sample</a>
<br> <a href="#Steps followed in the sample">Steps
in the sample</a>
<br>
<h2>
<a NAME="1.Overview of the Sample"></a><font face="Arial,Helvetica"><font color="#000099">Overview
of the Sample</font></font></h2>
This sample shows how
to return multiple recordsets from Oracle stored procedure and pass NVARCHAR2
parameters to stored procedure
<br> using OLEDB Interfaces
with VC++.
<p> With OraOLEDB, a variable
of type Ref Cursor is used as out parameter from a stored procedure or
return type of function to return the multiple
<br> records. This variable
in not required to be bound to the stored procedure in the calling application.
OraOLEDB automatically binds this variable
<br> and returns the records
appropriately. To enable OraOLEDB to bind Ref Cursor variable automatically,
the property 'ORAPROP_PLSQLRSet' is to be set
<br> to true. This involves
an extra network trip to database to bind the variable.
<p> The property can be
set either at the connection time or as command interface object
property just before executing the procedure.
<br> If the property is
set as connection attribute, OraOLEDB will perform an extra network trip
for every call to database. So it is a better practise to
<br> set the property to
'True' just before execution of the command using Ref Cursor and then setting
it to 'False'.
<p> When NLS data is to be passed
as a parameter to the stored procedure or SQL statement , the property
'ORAPROP_NDatatype' is to be set to
<br> true. This property can
be set to true through the command interface object just before execution
of command .
<p> The sample uses 'PRODUCT
INFORMATION' table from the schema provided with it.
<br>
<h2>
<a NAME="2.Software Requirements"></a><font face="Arial,Helvetica"><font color="#000099">Required
Software</font></font></h2>
Oracle 8x database .
<br> Visual C++ 6.0
<br> Oracle Provider for OLEDB
Release 8.1.7
<br>
<h2>
<a NAME="Assumptions"></a><font face="Arial,Helvetica"><font color="#000099">Assumptions</font></font></h2>
1. A database user e.g.. Oraole
with password Oraole has already been created.
<br> 2. The tables with data
used by the sample have already been created using the SQL scripts. Refer
db8setup.html for more information about
<br>
setting up the database tables and populating data.
<h2>
<font face="Arial,Helvetica"><font color="#000099"><font size=+1> <a NAME="Description of Files in the sample"></a></font>Description
of Files in the sample</font></font></h2>
<table BORDER COLS=4 WIDTH="100%" >
<tr>
<td WIDTH="4%">
<h4>
<font face="Arial,Helvetica"><font color="#000099">Sr No</font></font></h4>
</td>
<td WIDTH="10%">
<h4>
<font face="Arial,Helvetica"><font color="#000099">File Name</font></font></h4>
</td>
<td WIDTH="10%">
<h4>
<font face="Arial,Helvetica"><font color="#000099">Type</font></font></h4>
</td>
<td>
<h4>
<font face="Arial,Helvetica"><font color="#000099">File Description</font></font></h4>
</td>
</tr>
<tr>
<td>1</td>
<td> ReadMe.html</td>
<td>HTML File</td>
<td>ReadMe File for the project</td>
</tr>
<tr>
<td>2</td>
<td>OLEHandler.h</td>
<td>C++ header file</td>
<td>Declares the class for handling database functions.</td>
</tr>
<tr>
<td>3</td>
<td>OLEHandler.cpp</td>
<td>C++ source file</td>
<td>Contains implementation of the class for handling database functions.</td>
</tr>
<tr>
<td>4</td>
<td>OleMR.h</td>
<td>C++ header file</td>
<td>This is the startup file for the implementation. It contains declaration
of class derived from CWinApp</td>
</tr>
<tr>
<td>5</td>
<td>OleMR.cpp</td>
<td>C++ source file</td>
<td>Implementation file for class used to start up of the application</td>
</tr>
<tr>
<td>6</td>
<td>OleMRDlg.h</td>
<td>C++ header file</td>
<td>This file declares the class for start up dialog box of the application</td>
</tr>
<tr>
<td>7</td>
<td>OleMRDlg.cpp</td>
<td>C++ source file</td>
<td>This file contains the class implementation for start up dialog box.</td>
</tr>
<tr>
<td>8</td>
<td>PInfo.h</td>
<td>C++ header file</td>
<td>This file contains the class declaration for the Product Information
dialog
<br>box</td>
</tr>
<tr>
<td>9</td>
<td>PInfo.cpp</td>
<td></td>
<td>This file contains the class implementation for the Product Information
dialog box</td>
</tr>
<tr>
<td>10</td>
<td>InsertDlg.h</td>
<td>C++ header file</td>
<td>This file contains the class declaration for the 'Insert Product Details'
dialog
<br>box</td>
</tr>
<tr>
<td>11</td>
<td>InsertDlg.cpp</td>
<td>C++ source file</td>
<td>This file contains the class implementation for the 'Insert Product
Details' dialog box</td>
</tr>
<tr>
<td>12</td>
<td>OleMR.rc</td>
<td>Resource script file</td>
<td>This file contains definition of application resources</td>
</tr>
<tr>
<td>13</td>
<td>Resource.h</td>
<td>C++ header file</td>
<td>This file defines the constants for the resources used by the application</td>
</tr>
<tr>
<td>14</td>
<td>msflexgrid.h</td>
<td>C++ header file</td>
<td>This file contains definition for MSFlexgrid control class</td>
</tr>
<tr>
<td>15</td>
<td>msflexgrid.cpp</td>
<td>C++ source file</td>
<td>This file contains implementation for MSFlexgrid control class</td>
</tr>
<tr>
<td>16</td>
<td>font.h</td>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -