I have a pro*C program. It works fine at my development env but when it put on production it get crashed and gives "Heap consistency error", on first SELECT INTO statement.
EXEC SQL BEGIN DECLARE SECTION;
EXEC SQL END DECLARE SECTION;
SELECT USER_NAME INTO :v_user from USERS;
Can you please help me why is it so ?