From: | David Fetter <david(at)fetter(dot)org> |
---|---|
To: | "Sundaramoorthy, Annapoorani (Cognizant)" <Annapoorani(dot)Sundaramoorthy(at)cognizant(dot)com> |
Cc: | PostgreSQL General <pgsql-general(at)postgresql(dot)org>, "Sathyan, Sathish (Cognizant)" <Sathish(dot)Sathyan(at)cognizant(dot)com>, "Murugavel, Arun (Cognizant)" <Arun(dot)Murugavel(at)cognizant(dot)com> |
Subject: | Re: [BUGS] Execution of stored procedures |
Date: | 2006-01-19 07:40:58 |
Message-ID: | 20060119074058.GA7084@fetter.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs pgsql-general |
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!
From | Date | Subject | |
---|---|---|---|
Next Message | Surya | 2006-01-19 11:16:05 | BUG #2184: Insertion problem |
Previous Message | varun bhasin | 2006-01-19 07:01:00 | BUG #2183: Cannot enter Paragraph Type data |
From | Date | Subject | |
---|---|---|---|
Next Message | OpenMacNews | 2006-01-19 07:50:12 | using SSL client certs? |
Previous Message | Tom Lane | 2006-01-19 07:26:39 | Re: No heap lookups on index |