error 49 bad bind variable [message #535483] |
Wed, 14 December 2011 04:59 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
![](http://www.gravatar.com/avatar/892fd9ad41ffae42e983a9dc95b2cd72?s=64&d=mm&r=g) |
omernas
Messages: 3 Registered: June 2011 Location: sudan
|
Junior Member |
|
|
hi i am getting this error when compiling (error 49 bad bind variable) is there anything wrong in this
(
declare
total_rec number(2);
begin
:new_id:=null; :new_sal:=null;
:new_name:=null; :new_tel:=null;
:new_job:=null; :new_date:=null;
:new_address:=null;
total_rec:=to_number(GET_LIST_ELEMENT_COUNT('EMP_NAME_LIST'));
if GET_LIST_ELEMENT_LABEL('EMP_NAME_LIST',total_rec)is null then
:new_id:=1;
else
select nvl(max(ply_id),0)+1 into:new_id from employee;
end if;
SHOW_window('addd',40,40);
SET_ITEM_PROPERTY('dis1',VISIBLE,PROPERTY_false);
GO_ITEM('new_name');
end;
)
the code in the add-new command
when_button_pressed trigger
am adding employee to the employee table by this form
thanks in advance...
|
|
|
|