Re: [BUGS] Execution of stored procedures

On Thu, Jan 19, 2006 at 10:09:28AM +0530, Sundaramoorthy, Annapoorani (Cognizant) wrote:
>
> 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.

That would be an important hint. Look for the first SELECT in your
stored procedure. If it follows immediately doesn't look like either
this:

INTO target_1, ..., target_n -- note lack of comma here
column1, ... , column_n

or this:

column1, ... , column_n -- note lack of comma here
INTO target_1, ..., target_n

(modulo spacing), change it to PERFORM and try again. Repeat as
needed :)

Cheers,
David (moving this to -general, where it belongs)
--
David Fetter david(at)fetter(dot)org http://fetter.org/
phone: +1 415 235 3778

Remember to vote!