Solved

Calling an Oracle stored procedure from C

Posted on 2003-12-04
3
247 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

What Security Threats Are You Missing?

Enhance your security with threat intelligence from the web. Get trending threat insights on hackers, exploits, and suspicious IP addresses delivered to your inbox with our free Cyber Daily.

Join & Write a Comment

Summary: This tutorial covers some basics of pointer, pointer arithmetic and function pointer. What is a pointer: A pointer is a variable which holds an address. This address might be address of another variable/address of devices/address of fu…
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 recursion in the C programming language.
The goal of this video is to provide viewers with basic examples to understand how to create, access, and change arrays in the C programming language.

746 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

Need Help in Real-Time?

Connect with top rated Experts

11 Experts available now in Live!

Get 1:1 Help Now