Oracle C++ Call Interface. Programmer's Guide by Raphaely D., Gregoire J.

By Raphaely D., Gregoire J.

The Oracle C++ name Interface (OCCI) is an software programming interface (API) that permits functions written in C++ to have interaction with a number of Oracle database servers. OCCI offers your courses the power to accomplish the entire diversity of database operations which are attainable with an Oracle database server, together with SQL assertion processing and item manipulation.

Show description

By Raphaely D., Gregoire J.

The Oracle C++ name Interface (OCCI) is an software programming interface (API) that permits functions written in C++ to have interaction with a number of Oracle database servers. OCCI offers your courses the power to accomplish the entire diversity of database operations which are attainable with an Oracle database server, together with SQL assertion processing and item manipulation.

Show description

Read Online or Download Oracle C++ Call Interface. Programmer's Guide PDF

Best programming: programming languages books

Core C Sharp (Visual Studio 2.0 And Dot Net Sep

Due to the fact its free up no longer fairly 3 years in the past, C# has speedily won large utilization. This e-book is written for C# 2. zero, overlaying all of the new good points in 2. zero, together with generics. as well as its assurance of C#, it additionally presents info at the . web Framework and sessions that C# interacts with. each bankruptcy comprises questions and solutions in addition to recommended tasks.

iPhone Apps mit HTML, CSS und JavaScript: Ohne Objective-C und Cocoa zur eigenen App

IPhone Apps mit HTML, CSS and JavaScript: Ohne Objective-C und Cocoa zur eigenen App

Pro J2ME Polish : open source wireless Java tools suite

* the first e-book at the J2ME Polish open resource software * Written via Robert Virkus, the lead programmer and architect of J2ME Polish * Discusses each point of J2ME Polish in-depth, together with fitting, utilizing, and increasing * contains hands-on tutorials that inspire the reader to use their got wisdom

Extra info for Oracle C++ Call Interface. Programmer's Guide

Sample text

COMPRESS | NOCOMPRESS] Enter one of the options. Do not enter the vertical bar. Horizontal ellipsis points indicate either: ■ ■ That we have omitted parts of the code that are not directly related to the example CREATE TABLE ... AS subquery; That you can repeat a portion of the code SELECT col1, col2, ... , coln FROM employees; . . Vertical ellipsis points indicate that we have omitted several lines of code not directly related to the example. Other notation You must enter symbols other than brackets, braces, vertical bars, and ellipsis points as shown.

To specify the input parameters of a PL/SQL stored procedure, call the setxxx methods of the Statement class as you would for parameterized statements. stmt->setSQL("BEGIN countFruit(:1, :2); END:"); int quantity; stmt->setString(1, "Apples"); // specify the first (IN) parameter of procedure However, before calling a stored procedure, you need to specify the type and size of any OUT and IN/OUT parameters by calling the registerOutParam method. stmt->registerOutParam(2, Type::OCCIINT, sizeof(quantity)); // specify the type and size of the second (OUT) parameter You now execute the statement by calling the procedure: stmt->executeUpdate(); 2-10 Oracle C++ Call Interface Programmer’s Guide // call the procedure Types of SQL Statements in the OCCI Environment Finally, you obtain the output parameters by calling the relevant getxxx method: quantity = stmt->getInt(2); // get the value of the second (OUT) parameter Callable Statements with Arrays as Parameters A PL/SQL stored procedure executed through a callable statement can have array of values as parameters.

The details of linking an OCCI program vary from system to system. On some platforms, it may be necessary to include other libraries, in addition to the OCCI library, to properly link your OCCI programs. Introduction to OCCI 1-3 Overview of OCCI Functionality of OCCI OCCI provides the following functionality: ■ ■ ■ APIs to design a scalable, shared server application that can support large numbers of users securely SQL access functions, for managing database access, processing SQL statements, and manipulating objects retrieved from an Oracle database server Datatype mapping and manipulation functions, for manipulating data attributes of Oracle types Procedural and Nonprocedural Elements Oracle C++ Call Interface (OCCI) enables you to develop scalable, shared server applications on multitiered architecture that combine the nonprocedural data access power of structured query language (SQL) with the procedural capabilities of C++.

Download PDF sample

Rated 4.36 of 5 – based on 16 votes