ANJANE wrote:
> As I said the query works intermittently. Whenever it fails, I get the
> following error message
>
> ..select tp_get_clientusers('1','S%', 'rcursor');fetch all in rcursor;
>
> Microsoft OLE DB Provider for ODBC Drivers error '80004005'
>
> Error while executing the query; ERROR: pg_class_aclcheck: relation 6017860
> not found
>
> /portal/testdb.asp, line 82
>
> the relation oid keeps changing. Not sure what this means.
You can't create tables and use them safely in stored procedures unless
you treat
them via EXECUTE commands..
regards,
Hiroshi Inoue