Stored procedures returning cursors

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

1 messages

[T] Back to Threads [V] Tree View [G] Group Articles

1 total messages Started by Barba Mon, 26 Feb 2001 09:32

#5730

Author: 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?

Thread Navigation

This is a paginated view of messages in the thread with full content displayed inline.

Messages are displayed in chronological order, with the original post highlighted in green.

Use pagination controls to navigate through all messages in large threads.

Back to All Threads