how to initialize sqlca struct before execution each sql statement
Hi All,
I hate to do this (posting again to be on top of the list). I thought I would re-phrase my question.
After investigations, I found out that sqlca.sqlcode remains unchanged .
Please have a look following steps.
Steps :-
======
1) Execute Sql - select emp_name from emp where emp_id = 100.
Status :
sqlca.sqlcode is set to 142343
sqlca.sqlerrmc is set to :no_data_found.
2) Execute sql - select sequence.nextval from dual
Status :
sqlca.sqlcode is set to 142343
sqlca.sqlerrmc is set to :no_data_found.
Result : correct value is selected but the sqlca.sqlcode is not changed.
sqlca.sqlcode is set to 142343
sqlca.sqlerrmc is set to :no_data_found.
How can I initialize sqlca struct before execution of sqlca struct.
I am depending on the