Re: metadata for Storedprocedure

Hi, Sorry, you can't easily do that. Some DBMSes stored procedures
may say they return a result set (cursor) via an output parameter,
and other procedures may opaquely return an arbitrary series of
result sets that can differ based on arguments or the time of day.
You have to know something about the content of the procedure.

Joe Weinstein at BEA Systems.

.

Relevant Pages

  • Re: aout cursor staoed procedure and vb6 (ado)
    ... I correct stored procedure name of prefix ... cursor on runing row by row. ... > 2) The RETURN value is not an OUTPUT parameter. ... >> DECLARE curBsDetail CURSOR FOR ...
    (microsoft.public.data.ado)
  • Re: Stored Procedure, Output Value with SELECT Statement
    ... you are best off with the Set NoCount On in your procedure. ... your output parameter will only be available to your client code ... after you have read all of the select cursor on your client connection. ... load the recordset into an array or something so that you can get to ...
    (microsoft.public.data.ado)
  • Re: SP - output parameter not coming back
    ... The client side cursor did not help. ... If I do not find out about the output parameter I am considering ...
    (microsoft.public.inetserver.asp.db)
  • Re: Passing a table or cursor into a stored procedure
    ... Cursor can be used as OUTPUT parameter only not as Input-Output. ... cursor will alow stored procedure to return a cursor as output. ... >> Hari Sharma ...
    (microsoft.public.sqlserver.programming)
  • Re: Passing a table or cursor into a stored procedure
    ... Cursor can be used as OUTPUT parameter only not as Input-Output. ... cursor will alow stored procedure to return a cursor as output. ... >> Hari Sharma ...
    (microsoft.public.sqlserver)