Home » Developer & Programmer » Forms » How to know the success of an update statement using EXEC_SQL in forms 6i (Forms 6i, Oracle 8i)
How to know the success of an update statement using EXEC_SQL in forms 6i [message #316846] Mon, 28 April 2008 09:53 Go to next message
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

Re: How to know the success of an update statement using EXEC_SQL in forms 6i [message #317182 is a reply to message #316846] Tue, 29 April 2008 20:11 Go to previous message
djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia
Senior Member
Account Moderator
As you are not changing the table name, have you considered just using the 'rowcount'?
Update EMP SET sal=i.sql
 where emp_no=i.eno;
tt  := tt + sql%rowcount;

David
Previous Topic: IE7 closed itself when run oracle forms
Next Topic: Reminder
Goto Forum:
  


Current Time: Thu Nov 14 05:44:54 CST 2024