Re: [GENERAL] stored procedure which return a select result

2006-06-30 Thread A. Kretschmer
am 01.07.2006, um 7:47:09 +0200 mailte Alain Roger folgendes: [ Problems with set returning functions ] > Could you give me some piece of code for such use ? http://www.varlena.com/GeneralBits/26.php There are any examples. HTH, Andreas -- Andreas Kretschmer(Kontakt: siehe Header) Heyni

[GENERAL] stored procedure which return a select result

2006-06-30 Thread Alain Roger
Hi,I have some problems with a stored procedure.In this SP, i run several SELECT statements.1st one is to confirm that profile/account really exist into DB.if it's ok, the 2nd statement (SELECT) is executed and should return records. these records should be the result of my SP.i try the RETURNS set