ECPGdo - Mailing list pgsql-bugs

From Fabienne Leclere
Subject ECPGdo
Date
Msg-id 38F58530.3D45DC80@bira-iasb.oma.be
Whole thread Raw
List pgsql-bugs
============================================================================

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



Your name               :       Fabienne Leclere
Your email address      :       fabienne@oma.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

pgsql-bugs by date:

Previous
From: Guillaume Perréal
Date:
Subject: A date bug: number of day of October
Next
From: Fabienne Leclere
Date:
Subject: ecpg precompiler