Truncating a table in Pro*C

Dear netters,

I'm running Oracle 7 on Sun 4.1.3 and have written some code to truncate a table. Here's a simplified fragment:

#include "blah.h"

EXEC SQL BEGIN DECLARE SECTION;
    VARCHAR sqlstmt[2000];
EXEC SQL END DECLARE SECTION;   main()
{     

    /* connect to database removed */

    strcpy(sqlstmt.arr, "truncate table spdata");     sqlstmt.len = strlen(sqlstmt.arr);

    EXEC SQL PREPARE S FROM :sqlstmt;

    EXEC SQL EXECUTE S;
}

Unfortunately, when I step through the code in the debugger, it seems that the truncate occurs at the PREPARE, not at the EXECUTE. I've looked through the guide to Precompilers and no mention is made of using TRUNCATE, whether is allowed, not allowed, recommended, not recommended etc. Can someone tell me why this is happening?

Although it appears irrelevant in the above example when the truncation occurs, in the real code it matters heaps.

Thanks in advance,

Lincoln. Received on Wed Jun 08 1994 - 17:49:56 CEST