My Oracle Support Banner

Oracle Clinical Data Capture APIs Sample Code (Doc ID 315201.1)

Last updated on DECEMBER 06, 2019

Applies to:

Oracle Clinical - Version 5.0.1 and later
Generic Windows



This article is a tutorial and sample code on writing C and Pro*C programs to work in the context of Oracle Clinical version 5.0.1, 5.1.0 and 5.2.0. The intended audience consists of programmers working in the context of the Oracle Clinical with knowledge of the C programming language and Microsoft Visual Studio editor. Before attempting to test this sample code on your system, you should first verify that you have a working compiler (Visual Studio 2010) that is accessible to you and that you have the supported tech stack install for your release of Oracle Clinical. The Oracle Pro*C needed to compile the sample code is located under the Oracle Application Forms and Reports Server components of your tech stack installation.

During precompilation, Pro*C generates C code that replaces the SQL statements embedded in your host program. The generated code contains data structures that indicate the datatype, length, and address of host variables, as well as other information required by the Oracle runtime library, SQLLIB for the precompiler suite of languages. The generated code also contains the calls to SQLLIB routines that perform the embedded SQL operations.

The sample code provided is a Pro*C file and must be precompiled against the required Pro*C version before it can be used. To get an executable program, you must compile the output .c source files produced by the precompiler, then link the resulting object modules with modules needed from SQLLIB and system-specific Oracle libraries.

To use this sample code, you must link this sample application with the SQLLIB import libraries that correspond to the Pro*C DLLs and also DCAPI specific library.

Pre-requisite for running the sample Data Capture API code

You must ensure that the DLL files (DCAPI.dll, orasql11.dll, etc.) are installed on the computer that is running your sample Pro*C application.When running the sample application, DCAPI.DLL should be in the same directory as where the sample application executable is located.


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.