CREATE PROCEDURE "retrieve_results" (UID INTEGER)
AS
RETURNS (results AS RESULTSET)
BEGIN
SELECT * FROM tbl_names WHERE uid = :uid;
SUSPEND;
END;

----- Original Message -----
From: <stephen@...>
To: IBDI Mailing List <IBDI@yahoogroups.com>
Sent: Saturday, January 27, 2001 12:38 PM
Subject: [IBDI] Resultsets and stored procedures.


> -----BEGIN PGP SIGNED MESSAGE-----
> Hash: SHA1
>
>
> - -----BEGIN PGP SIGNED MESSAGE-----
> Hash: SHA1
>
> Hello all,
>
> I was wondering how I can return a result set from a stored procedure?
>
> I need somthing like the following:
>
>
> CREATE PROCEDURE "retrieve_results" (UID INTEGER)
> AS
> RETURNS (results AS RESULTSET)
> BEGIN
> SELECT * FROM tbl_names WHERE uid = :uid;
> END;
>
>
> Any idea how I can do this?
>
>
> Thanks.
>
>
> Stephen.
> - -----BEGIN PGP SIGNATURE-----
> Version: GnuPG v1.0.4 (GNU/Linux)
> Comment: For info see http://www.gnupg.org
>
> iD8DBQE6cf+oPmm0AnNwb5MRAgu0AKCDXsFOY8WNQQgQy36RI5EWqpl/JgCePI0/
> YSBtMhmB3cvqssJswoaHKmg=
> =NUzY
> - -----END PGP SIGNATURE-----
> -----BEGIN PGP SIGNATURE-----
> Version: GnuPG v1.0.4 (GNU/Linux)
> Comment: For info see http://www.gnupg.org
>
> iD8DBQE6crM8Pmm0AnNwb5MRAtSBAJ0d1M67MWbpHGtcm36ZWzYZx2ByFgCfXOjD
> il3gLU0PHOLPskImAZx3VZk=
> =zi1G
> -----END PGP SIGNATURE-----
>
> Community email addresses:
> Post message: IBDI@onelist.com
> Subscribe: IBDI-subscribe@onelist.com
> Unsubscribe: IBDI-unsubscribe@onelist.com
> List owner: IBDI-owner@onelist.com
>
> Shortcut URL to this page:
> http://www.onelist.com/community/IBDI
>