Re: Execution of stored procedures

Sundaramoorthy, Annapoorani (Cognizant) wrote:
>
> Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
> Error while executing the query; ERROR: SELECT query has no destination
> for result data
>
> HINT: If you want to discard the results, use PERFORM instead.
>
> This error is associated with the execution of stored procedure.
>
> Select <functuion_name()>;
>
> Is the way in which I am trying to execute the procedure in pgadmin and
> also this is the way in which I am using it in the asp file.

If it gives you the same error from pgadmin then it's clearly not an
ODBC error. The error message suggests to me that the problem is in the
function itself where you may be executing a SELECT without putting its
results into a variable.

You would probably get more answers on the plpgsql-general list. This
mailing list is for bugs in the PostgreSQL server itself. See you there!

--
Richard Huxton
Archonet Ltd