Re: EXEC syntax for SP which returns row set

From: Mark A <nobody_at_nowhere.com>
Date: Thu, 14 Jul 2005 23:05:34 -0600
Message-ID: <z6Cdnahwu6GB2UrfRVn-iQ@comcast.com>

"Mark Townsend" <markbtownsend_at_comcast.net> wrote in message news:42D7429F.9040705_at_comcast.net...

> I would be interested in seeing one. I guessing in the syntax there has to
> be some sort of interface definition of the result set being returned,
> otherwise how does the calling program know what is going to come back at
> it ? Something somewhere has to allocate the memory, and either side of
> the interface, both program blocks have to agree how to refer to that
> memory.

Keep in mind that I am talking about a command line interface, not an application program. The result set just prints out on the output, sort of like it does when you say "print results" as the final step in SQL*Plus.

I am not trying to make a big deal about this. I really just needed to quickly test an Oracle SP from SQL*Plus, and I didn't really care what I needed to do or how many commands where necessary, I just needed to know how to do it. Received on Fri Jul 15 2005 - 00:05:34 CDT