DB insert Error - Mailing list pgsql-novice

From Jasbinder Bali
Subject DB insert Error
Date
Msg-id a47902760608152055i4ecfc682v6f8b6a88901d9202@mail.gmail.com
Whole thread Raw
Responses Re: [GENERAL] DB insert Error
List pgsql-novice
Hi,
I'm using ECPG and trying to do follwoing insert in one of the talbes.
 
 insert into raw_email ( id  , raw_email  ) values ( 1 , :ch);
 
ch is an array and defined as follows:
 
 EXEC SQL BEGIN DECLARE SECTION;
    char ch[MSG_LEN];
EXEC SQL END DECLARE SECTION;
 
contents of array ch is actually a parsed raw email that i've attached herewith.
 
I get the following error when the insert statement is hit:
 
[2446]: ECPGexecute line 97: Error: ERROR:  array value must start with "{" or dimension information.
 
No clue what this error is all about. I googled for this error, found a few results but that didn't help much.
 
Thanks,
~Jas
 
 
 
 
Attachment

pgsql-novice by date:

Previous
From: "Jaime Casanova"
Date:
Subject: Re: Return type for procedure
Next
From: Michael Fuhr
Date:
Subject: Re: [GENERAL] DB insert Error