| Find an error line in PLSql [message #589090] |
Tue, 02 July 2013 03:11  |
 |
kolpalamayaw
Messages: 9
Registered: May 2013
Location: TURKEY
|
Junior Member |
|
|
Hi all,
I have question about my plsql code. First of all, I am new in plsql. I have code when I run it, I need to get error line. So I put on the some control. When I run it I get a message like this 'v_yer=2' My code is below. My question is the is there a problem between v_yer=1 and v_yer=2?
or
is there a problem after v_yer=2
I know that it is so basic question but I think Im so confuse it. Thank for u guys helping me...
Here is the code:
v_yer:=1;
v_ret:=its.GetSigortali(:tazminilacm.Kurum,:tazminilacm.PosKartNo,:control.grupid,:control.polid,:control.pid,:control.temsnf,:contro l.donemno,
:tazminilacm.Recetetarihi,v_TcKimlikNo,:control.AdSoyad,:control.Cinsiyet,v_DogumTarihi,:tazminilacm.polbastar,:tazminilacm.IlkSigort alanmaTarihi,
:tazminilacm.PoliceyeGirisTarihi,:tazminilacm.PolicedenCikisTarihi,:tazminilacm.kuralsetno,:tazminilacm.istisna,:tazminilacm.istisnas tatus,
:tazminilacm.odsek,:tazminilacm.HataKodu,:control.HataMesaji);
v_yer:=2;
If :tazminilacm.odsek='S' and :control.zarfGrupid is null Then
Update Tazzarf set Grupid=:Control.Grupid
where zarfno=:Tazminilacm.zarfno;
:control.ZarfGrupid:=:control.Grupid ;
End If;
Commit_Form;
|
|
|
|
|
|
|
|
|
|
| Re: Find an error line in PLSql [message #589100 is a reply to message #589095] |
Tue, 02 July 2013 03:40  |
|
kolpalamayaw
Messages: 9
Registered: May 2013
Location: TURKEY
|
Junior Member |
|
|
Sorry my fault it allrady has v_yer:=1 and v_yer:=2
I use oracle form and it works perfectly generally. Only one record which is run, It gave me this this message. It should be problem between v_yer:=1 and v_yer:=2. But I just wanna make sure.
By the way thanks for reply LieToMe
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
