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 [EMAIL PROTECTED] Tue Apr 15 20:24:47 2003 X-MultiHeader: one X-MultiHeader: two X-MultiHeader: three From: Simon Cozens <[EMAIL PROTECTED]> To: test Bcc: [EMAIL PROTECTED] 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 [EMAIL PROTECTED] address is deprecated due to being broken. [EMAIL PROTECTED] 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=
---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message can get through to the mailing list cleanly
