Solved

Calling an Oracle stored procedure from C

Posted on 2003-12-04
3
266 Views
Last Modified: 2010-04-15
I need help in calling an oracle stored procedure from C
0
Comment
Question by:AnjuThomas
3 Comments
 

Accepted Solution

by:
magashi earned 25 total points
ID: 9919536
You can use the oracle vendor specific library OCI if you program in C, anyway I may recommend you to take a look on OTL a third party library, it encapsulates OCI functions in C++ for easy use.
If you already use these libraries:
you got just to prepare your statement as any other one, and the call method is the same as under sqlplus.

stmt="BEGIN your_proc(parameters) ; END;"
If u are used to program with the libraries above the steps following execution are the same.
Hope that helps you
good luck,
magesh
0

Featured Post

U.S. Department of Agriculture and Acronis Access

With the new era of mobile computing, smartphones and tablets, wireless communications and cloud services, the USDA sought to take advantage of a mobilized workforce and the blurring lines between personal and corporate computing resources.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Windows programmers of the C/C++ variety, how many of you realise that since Window 9x Microsoft has been lying to you about what constitutes Unicode (http://en.wikipedia.org/wiki/Unicode)? They will have you believe that Unicode requires you to use…
This is a short and sweet, but (hopefully) to the point article. There seems to be some fundamental misunderstanding about the function prototype for the "main" function in C and C++, more specifically what type this function should return. I see so…
The goal of this video is to provide viewers with basic examples to understand and use structures in the C programming language.
The goal of this video is to provide viewers with basic examples to understand recursion in the C programming language.

776 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question