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;
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
From simon@xxxxxxxxxxxxxxxx Tue Apr 15 20:24:47 2003 X-MultiHeader: one X-MultiHeader: two X-MultiHeader: three From: Simon Cozens <simon@xxxxxxxxxxxxxxxx> To: test Bcc: simon@xxxxxxxxxxx Subject: foo Mime-Version: 1.0 Content-Type: image/gif Content-Disposition: attachment; filename="1.gif" Content-Transfer-Encoding: base64 X-Operating-System: Linux deep-dark-truthful-mirror 2.4.9 X-POM: The Moon is Waxing Gibbous (98% of Full) X-Addresses: The simon@xxxxxxxxxx address is deprecated due to being broken. simon@xxxxxxxxxxxx still works, but simon-cozens.org or netthink.co.uk are preferred. X-Mutt-Fcc: =outbox-200304 Status: RO Content-Length: 1205 Lines: 17 R0lGODlhDAAMAPcAAAAAAAgICBAQEBgYGCkpKTExMTk5OUpKSoyMjJSUlJycnKWlpbW1tc7O zufn5+/v7/f39/////////////////////////////////////////////////////////// //////////////////////////////////////////////////////////////////////// //////////////////////////////////////////////////////////////////////// //////////////////////////////////////////////////////////////////////// //////////////////////////////////////////////////////////////////////// //////////////////////////////////////////////////////////////////////// //////////////////////////////////////////////////////////////////////// //////////////////////////////////////////////////////////////////////// //////////////////////////////////////////////////////////////////////// //////////////////////////////////////////////////////////////////////// //////////////////////////////////////////////////////////////////////// //////////////////////////////////////////////////////////////////////// //////////////////////////////////////////////////////////////////////// /////////////////////////////////ywAAAAADAAMAAAIXwAjRICQwIAAAQYUQBAYwUEB AAACEIBYwMHAhxARNIAIoAAEBBAPOICwkSMCjBAXlKQYgCMABSsjtuQI02UAlC9jFgBJMyYC CCgRMODoseFElx0tCvxYIEAAAwkWRggIADs=
