From: | "Jasbinder Bali" <jsbali(at)gmail(dot)com> |
---|---|
To: | pgsql-novice(at)postgresql(dot)org, pgsql-general(at)postgresql(dot)org |
Subject: | DB insert Error |
Date: | 2006-08-16 03:55:58 |
Message-ID: | a47902760608152055i4ecfc682v6f8b6a88901d9202@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general 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 | Content-Type | Size |
---|---|---|
contents.txt | text/plain | 1.9 KB |
From | Date | Subject | |
---|---|---|---|
Next Message | Michael Fuhr | 2006-08-16 04:19:45 | Re: DB insert Error |
Previous Message | Michael Fuhr | 2006-08-16 01:31:31 | Re: Connection string |
From | Date | Subject | |
---|---|---|---|
Next Message | Michael Fuhr | 2006-08-16 04:19:45 | Re: DB insert Error |
Previous Message | Jaime Casanova | 2006-08-16 03:28:53 | Re: Return type for procedure |