Skip Headers
Oracle® Objects for OLE C++ Class Library Developer's Guide
10g Release 2 (10.2)

Part Number B14308-01
Go to Documentation Home
Home
Go to Book List
Book List
Go to Table of Contents
Contents
Go to Index
Index
Go to Master Index
Master Index
Go to Feedback page
Contact Us

Open (OSqlStmt) Method

Applies To

OSqlStmt

Description

This method opens a SQL statement.

Usage

oresult Open(const ODatabase &odb, const char *sql_statement, long options = OSQLSTMT_DEFAULT);

Arguments

Arguments
Description
odb
The database with which to open this dynaset.
sqlstmt
A valid select SQL statement.
options
Options to be used to create the OSqlStmt instance. Valid options are:
OSQLSTMT_DEFAULT
OSQLSTMT_NOBIND
OSQLSTMT_FAILEXEC

Remarks

The OSQLSTMT_FAILEXEC option forces an error when there is an error executing the sql statement.

Return Value

An oresult indicating whether the operation succeeded (OSUCCESS) or not (OFAILURE).

Example

oresult res;
OSession osess;
OStartup();
osess.Open();
ODatabase odb(osess, "exampledb", "scott", "tiger");
OSqlStmt osql;
osql.Open(odb, "insert into  emp(empno, deptno) values (99,10)", 
          OSQLSTMT_FAILEXEC);