PostgreSQL for Windows - HOW TO RETRIEVE VALUE FROM TEMP TABLE ON THE INTERFACE

Author

HOW TO RETRIEVE VALUE FROM TEMP TABLE ON THE INTERFACE

Vasudeva, Rahul

2006-01-14, 3:23 am

Hi,

I am executing a stored procedure from an ASP page without any input
parameters, in that stored procedure two sql queries are executed and
the result is stored in a temporary table, now I want to retrieve the
recordset of that temp table on the interface.

There is an error every time on the Interface "Invalid Object" ,
although I am dropping the temp table explicitly .

Thanks & Regards

Rahul Vasudeva.

This message contains information that may be privileged or confidentialand is the property of the Capgemini Group. It is intended only for theperson to whom it is addressed. If you are not the intended recipient, you are not authorized to read, print, retain, copy, disseminate, distribute, or use this message or any part thereof. If you receive thismessage in error, please notify the sender immediately and delete all copies of this message.

Jaime Casanova

2006-01-14, 8:23 pm

On 1/10/06, Vasudeva, Rahul <rahul.vasudeva@capgemini.com> wrote:
>
>
>
> Hi,
>
>
>
> I am executing a stored procedure from an ASP page without any input parameters, in that stored procedure two sql queries are executed and the result is stored in a temporary table, now I want to retrieve the recordset of that temp table on the inte
rface.
>
>
>
> There is an error every time on the Interface "Invalid Object" , although I am dropping the temp table explicitly ..
>
>
>
> Thanks & Regards
>
> Rahul Vasudeva.
>
>

As you have already notice, there are little people looking as this
list... that is because now that we have a native port to windows use
the cygwin version is deprecated... and i am suggesting you to do that
as soon as possible...

There other list you can write here: http://www.postgresql.org/community/lists/

About your question the reason is that temp tables un functions must
be declared within a EXECUTE... something like:

CREATE FUNCTION ffoo() RETURNS void AS $$
DECLARE
EXECUTE 'CREATE TEMP TABLE tmp_foo (fld int4)'
END;
$$ LANGUAGE 'plpgsql';

--
Atentamente,
Jaime Casanova
(DBA: DataBase Aniquilator ;)

---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo@postgresql
.org so that your
message can get through to the mailing list cleanly

Sponsored Links