Stored procedures returning cursors

Article View: borland.public.cppbuilder.database.ado

Article #5730

Back to borland.public.cppbuilder.database.ado Previous Next

#5730

From: Barba
Date: Mon, 26 Feb 2001 09:32

12 lines
1460 bytes

I am trying to use a TADOStoredprc to call a Oracle 8i stored procedure with
2 parameters
that returns a cursor in its second parameter (the procedure is something
like "select * from table where field1 = param1")
Using a tadostoredproc component, and specifying the procedure name, I get a
parameter
list where I can see the first imput parameter, the second parameter (the
cursor!!!) with a type of ftInterface (???)  and a list of other parameters
that are all the field retrieved by the query.
I cannot change the second parameter to ftcursor type. and I cannot set the
active property of the tadostoredproc to true
Can anyone help me?

Technical Details

Message-ID: <3a9a2284_1@dnews>

Path:

arc1-ca.pugleaf.net!supernews.google.com!sn-xit-03!supernews.com!logbridge.uoregon.edu!hammer.uoregon.edu!feed.textport.net!news.bnb-lp.com!bornews.borland.com!dnews!212.216.73.245

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: 10698b,65298c365a5856fa,start
X-Google-Attributes: gid10698b,public
X-Google-ArrivalTime: 2001-02-26 01:42:05 PST
From: "Barba" <epriale@logosystem.com>
Newsgroups: borland.public.cppbuilder.database.ado
Subject: Stored procedures returning cursors
Date: Mon, 26 Feb 2001 10:32:39 +0100
Lines: 15
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 5.00.2919.6600
X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2919.6600
NNTP-Posting-Host: 212.216.73.245
Message-ID: <3a9a2284_1@dnews>
X-Trace: 26 Feb 2001 01:31:48 -0800, 212.216.73.245
Path: arc1-ca.pugleaf.net!supernews.google.com!sn-xit-03!supernews.com!logbridge.uoregon.edu!hammer.uoregon.edu!feed.textport.net!news.bnb-lp.com!bornews.borland.com!dnews!212.216.73.245