Pro*C Dynamic SQL PREPARE size restriction

From: (wrong string) åg <kjell.walvag_at_sds.no>
Date: Tue, 15 Jun 1999 14:25:27 +0200
Message-ID: <7k5gip$evu$1_at_krabbe.interpost.no>



Hi

When I use Pro*C dynamic SQL method 3 PREPARE statement with a SELECT statement = 2000 characters I get a core dump (AIX platform). When the size is less than approx. 1024 characters all works fine. Is there a length restriction in the statement, and if the case does anybody know a workaround?

My statements:
char sql_string[4096];
strcpy(sql_string,............);
EXEC SQL PREPARE sql_stmnt FROM :sql_string;
/*=> core dump when strlen(sql_string) > 1024 !*/

-Kjell- Received on Tue Jun 15 1999 - 14:25:27 CEST

Original text of this message