Re: Stored Procedures and Describe with V5

In article <1993May12.010554.23360@informix.com>, aland@informix.com (Colonel Panic) writes: > In article <1993May11.144352@ap.mchp.sni.de> franz.krojer@ap.mchp.sni.de (Ein Teeist) writes: > >In the manuals of Informix V5.0 I can't see any > >possibility of describing a stored procedure. > > > >Is this right? > > Not unless you have the wrong manuals. Chapter 8 of the SQL Reference is > all about stored procedures and SPL. Also see CREATE PROCEDURE syntax on page > 7-53, and discussions about creating and using stored procedures in chapter > 11 of the SQL Tutorial. > My question was perhaps to short. I wan't PREPARE and DESCRIBE a Stored Procedure like a dynamic SQL-Statement. I want all the parameters and their types from a Stored Procedures returned from the DBMS and not an optional comment. "Describe" of a Stored Procedures in the Manuals is only a help or usage text but not a dynamic DESCRIBE-Statememt. -- Franz Krojer, SNI AP 154 Otto-Hahn-Ring 6, D-8000 Muenchen 83, Germany email: franz.krojer@ap.mchp.sni.de