Thread: Execution of stored procedures

Hi,

I am migrating from MS SQL to POSTGRESQL database.

In this, I have some problem with the ASP connection. The error is as
follows:

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.

=0D

=0D

This error is associated with the execution of stored procedure.

=0D

Select <functuion_name()>;

=0D

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.

Can I have your help in overcoming the issue.

=0D

=0D

Thanks.

Annapoorani S

=0D

=0D



This e-mail and any files transmitted with it are for the sole use of the i=
ntended recipient(s) and may contain confidential and privileged informatio=
n.
If you are not the intended recipient, please contact the sender by reply e=
-mail and destroy all copies of the original message.=0D
Any unauthorized review, use, disclosure, dissemination, forwarding, printi=
ng or copying of this email or any action taken in reliance on this e-mail =
is strictly=0D
prohibited and may be unlawful.

  Visit us at http://www.cognizant.com=

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