Hi,
We upgraded our servers from solaris 9 to 10. We recompiled all the Pro*C programs with the new oracle version as well. Oracle is 11g. We are facing core dump with the below error for certain executions. But when we are placing new statements between the error fucntion we get junk values to the output files.
Replace_Char(l_exp_descr, SPACE, (char)NULL, TRAILING);
/*int len_type=strlen(l_expense_type);
int len_descr=strlen(l_exp_descr); */
EXEC SQL
SELECT subaccount
INTO :local_subaccount
FROM btadmin.gce_exp_sub_cd
WHERE exp_type = trim(:l_expense_type) AND
exp_descr = trim(:l_exp_descr) AND
site = :what_site;