ECPGdo

From: Fabienne Leclere <fabienne(at)bira-iasb(dot)oma(dot)be>
To: pgsql-bugs(at)postgresql(dot)org
Subject: ECPGdo
Date: 2000-04-13 08:28:33
Message-ID: 38F58530.3D45DC80@bira-iasb.oma.be
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

============================================================================

POSTGRESQL BUG REPORT TEMPLATE
============================================================================

Your name : Fabienne Leclere
Your email address : fabienne(at)oma(dot)be

System Configuration
---------------------
Architecture (example: Intel Pentium) : HP 9000 serie E

Operating System (example: Linux 2.0.26 ELF) : HPUX 11.0

PostgreSQL version (example: PostgreSQL-6.5.3): PostgreSQL-6.5.3

Compiler used (example: gcc 2.8.0) : aCC HP aC++ B3910B
A.03.13

Please enter a FULL description of your problem:
------------------------------------------------
With the ecpg precompiler:
when using a table with 2 varchar, It is impossible to insert 2 varchar
simultaneously into that table.
The problem seem to be in the ECPGdo function.
I receive an error : -201 Too many arguments

Please describe a way to repeat the problem. Please try to provide a
concise reproducible example, if at all possible:
----------------------------------------------------------------------
1) create table ttest ( data1 varchar(200), data2 varchar(200));

2) edit the .pc file:

...
exec sql begin declare section;

varchar bla1[4000];
varchar bla2[4000];

exec sql end declare section;
...
exec sql insert into ttest values ( :bla1,:bla2);
....

3) precompile and compile

4) execution give after insert
a value of -201 for sqlca.sqlcode
a message "Too many arguments" for sqlca.sqlerrm.sqlerrmc

Browse pgsql-bugs by date

  From Date Subject
Next Message Fabienne Leclere 2000-04-13 09:41:01 ecpg precompiler
Previous Message Guillaume Perréal 2000-04-13 07:29:02 A date bug: number of day of October