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:
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.
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!
In response to
pgsql-interfaces by date
|Next:||From: Michael Meskes||Date: 2004-06-22 06:53:10|
|Subject: Re: 'execute immediate' problem|
|Previous:||From: L J Bayuk||Date: 2004-06-21 01:05:54|
|Subject: Released updated Tcl interfaces: pgin.tcl-2.1.0, pgtclng-1.5.1|