[SQL] Stored Procedure Problem

Thu, 12 Dec 2002 05:32:36 -0800

Hello,

 

                Atul Here, I have one problem while accessing Database Records Or Recordset from stored procedure. Procedure is like this,

 

CREATE FUNCTION b_function() RETURNS int4 AS '

DECLARE

   an_integer int4;

BEGIN

   select emp_id from employee;

   return an_integer;

END;

'

LANGUAGE 'plpgsql';

 

I create the procedure . After that I run the statement like

 

Test=#> select b_function();

 

Error comes like

 

Error: ERROR:  SELECT query has no destination for result data.

                If you want to discard the results, use PERFORM instead.

WARNING:  Error occurred while executing PL/pgSQL function b_function

WARNING:  line 4 at SQL statement

 

Also I use PERFORM statement. But still problem is not resolved.

 

Please Help me. I hope your kind co-operation.

 

Thanks.

 

Atul…

Reply via email to