How to know the success of an update statement using EXEC_SQL in forms 6i [message #316846] |
Mon, 28 April 2008 09:53 |
vishubms
Messages: 10 Registered: October 2006 Location: Bangalore
|
Junior Member |
|
|
Dear Techies........
I am using Exec_SQL to update main table from remote site, the problem is that, to increase the performance there is no select statement included in the code, it straight away updating the main table without any checking, but we want to know the success of the update statement, we used EXEC_SQL.LAST_ROW_COUNT but it didnt serve our purpose, is there any way to achive this..
I am using Forms 6i & Oracle 8i
The code is as follws
V_Update := 'Update EMP SET sal='||''''||i.sql||''''||
'where emp_no='||''''||i.eno||''''||';';
EXEC_SQL.Parse(connection_id,cursor_id,V_Update);
Log_ID:=EXEC_SQL.Execute(connection_id,cursor_id);
I want to know whether the update statement is success or failed.. and how many rows updated....
please let me know the solution.....
Thanx & Regards,
Vishwanath N
[Updated on: Mon, 28 April 2008 09:55] Report message to a moderator
|
|
|
|