Home » RDBMS Server » Server Administration » Calling stored procedure from VC++
Calling stored procedure from VC++ [message #57547] Sat, 21 June 2003 23:29 Go to next message
Sheila
Messages: 28
Registered: May 1998
Junior Member
Please give me an example of how to call a stored procedure that returns multiple rows from VC++ via OCI.

Report message to a moderator

Re: Calling stored procedure from VC++ [message #57550 is a reply to message #57547] Sun, 22 June 2003 09:10 Go to previous message
sai sreenivas jeedigunta
Messages: 370
Registered: November 2001
Senior Member
Hello ,
you hav to use the REF cursor concept in stored procedure to return multiple rows that should be captured by VC++.

create or replace package mypack
type rc is ref cursor;
end mypack;

create or replace procedure mypro(a out mypack.rc%type)
as
open a for select statement..
end myproc..

please dont follow the syntax...I dont remember it correctly..
check the OO4O (oracle objects for OLE) documentation & Metalink for furthur reference.

Regards
sai

Report message to a moderator

Previous Topic: OFA
Next Topic: Database Storage Capacity
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Sep 20 10:28:53 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.