show SP result set

Article View: borland.public.interbase.sql

Article #923

Back to borland.public.interbase.sql Previous Next

#923

From: aleplgr
Date: Thu, 26 Apr 2007 09:01

3 lines
1143 bytes

Hi! In a stored procedure I process a table and to show it to the end user now I  have to execute a SELECT at the client side,out of the SP, this SELECT shows the end user a 4 columns,500 rows table. 
Is it possible to execute the SELECT in the SP? so that the end user only runs the SP and it returns the result table without having to run the SELECT after the execution of the stored procedure.

Technical Details

Message-ID: <46306a55$1@newsgroups.borland.com>

Path:

arc1-ca.pugleaf.net!g2news1.google.com!news4.google.com!news.germany.com!newsfeed01.sul.t-online.de!t-online.de!newsgroups.borland.com!not-for-mail

Show Full Headers

Complete Article Headers

X-Google-Thread: 114a0e,87ed5f859036b198,start
X-Google-Attributes: gid114a0e,public
X-Google-Language: ENGLISH,ASCII-7-bit
From: "aleplgr" <aleplgr@yahoo.es>
Sender: "aleplgr" <aleplgr@yahoo.es>
Reply-To: "aleplgr" <aleplgr@yahoo.es>
Subject: show SP result set
Newsgroups: borland.public.interbase.sql
X-User-Info: 80.58.205.38     
X-Forwarded-For: 80.25.195.180, 192.168.1.66
NNTP-Posting-Host: 207.105.83.66
Message-ID: <46306a55$1@newsgroups.borland.com>
Date: 26 Apr 2007 02:01:09 -0700
X-Trace: newsgroups.borland.com 1177578069 207.105.83.66 (26 Apr 2007 02:01:09 -0700)
Lines: 3
Path: arc1-ca.pugleaf.net!g2news1.google.com!news4.google.com!news.germany.com!newsfeed01.sul.t-online.de!t-online.de!newsgroups.borland.com!not-for-mail