A Stored Procedure in SQL Server returning a recordset

From: Khash Sajadi (khash_at_ksajadi.com)
Date: 01/20/04 

Date: Tue, 20 Jan 2004 14:10:38 -0800

This is the header of my stored procedure

CREATE PROCEDURE dbo.Test
 (@P1 INT,
  @P2 CURSOR VARYING OUTPUT)

It works fine within SQL query analyzer.

But when I try to call it from within Delphi ADOStoredProcedure, the
component recognizes P2 as an InputOutput Integer (instead of cursor) and an
attempt to execute it causes an ADO exception saying int type is not
compatible with cursor. When I try to define the parameters manualy (either
in design or run time) I get another exception saying Argumnets are of the
wrong type,...

May I ask if anyone has tried calling stroed procedures with a CURSOR OUTPUT
parameter. I am open to using any kind of ADO component (Query, Command,
StoredProcedure...)

Many thanks,

Khash

Relevant Pages