Re: Interesting ECPG error

On Fri, Jun 18, 2004 at 05:11:01PM -0400, Owens, Steve wrote:
>
> I'm running 7.4.2 and using ECPG's dynamic SQL capabilities to run some pgplsql functions in a database, some of which just insert records into a table. The dynamic SQL statement looks something like this:
> ...

Could you please run your program with logging enabled? Therefore you
just have to add this at the beginning of your program:

FILE *dbgs;
if ((dbgs = fopen("log", "w")) != NULL) ECPGdebug(1, dbgs);

and an fclose(dbgs) at the end of course. This creates a file named
"log". Then please send me that file. I'd like to see what's going on.

-220 btw is "No Connection" so I assume you mean -202 which is given if
a "?" is left after processing of all variables.

Also could you please send me the .pgc file and your .c file, i.e.
ecpg's output? Preferably in a small test case.

Thanks.

Michael
--
Michael Meskes
Email: Michael at Fam-Meskes dot De
ICQ: 179140304, AIM/Yahoo: michaelmeskes, Jabber: meskes(at)jabber(dot)org
Go SF 49ers! Go Rhein Fire! Use Debian GNU/Linux! Use PostgreSQL!