-----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-----