ECPGdo

Started by Fabienne Leclereabout 26 years ago1 messagesbugs
Jump to latest
#1Fabienne Leclere
fabienne@bira-iasb.oma.be

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

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