?
Solved

Calling an Oracle stored procedure from C

Posted on 2003-12-04
3
Medium Priority
?
289 Views
Last Modified: 2010-04-15
I need help in calling an oracle stored procedure from C
0
Comment
Question by:AnjuThomas
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
3 Comments
 

Accepted Solution

by:
magashi earned 100 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

Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

Question has a verified solution.

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

Have you thought about creating an iPhone application (app), but didn't even know where to get started? Here's how: ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ Important pre-programming comments: I’ve never tri…
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 pointers in the C programming language.
The goal of this video is to provide viewers with basic examples to understand and use structures in the C programming language.

719 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