|sequence on code [message #251890]
||Tue, 17 July 2007 01:55
Registered: August 2006
i m facing problem. unable to solve can u please point out my mistake.
my requirement is to provide serial no or code to new entry.
where vc_control_code = 'Q'
and vc_comp_code = :global.vc_comp_code
for update of nu_end_number nowait;
when others then
IF dbms_error_code = -54 or error_code = 40735 Then
'This record is being modified by another user. Try again !');
alt_var := show_alert('alrt_date');
while adding new entry i got the message
'This record is being modified by another user. Try again !'
please suggest me what i had done mistake on
sir please dont provide me other code. modify on my code
[Updated on: Tue, 17 July 2007 02:10]
Report message to a moderator