Re: [BUGS] Execution of stored procedures

#1

Sundaramoorthy, Annapoorani (Cognizant) wrote:

Quote:

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

---------------------------(end of broadcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Re: [BUGS] Execution of stored procedures

mailing.database.pgsql-bugs mailing.database.pgsql-bugs

Re: [BUGS] Execution of stored procedures - 01-19-2006 , 10:01 AM