Home » Developer & Programmer » Forms » Find an error line in PLSql
Find an error line in PLSql [message #589090] Tue, 02 July 2013 03:11 Go to next message
kolpalamayaw
Messages: 7
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 #589092 is a reply to message #589090] Tue, 02 July 2013 03:14 Go to previous messageGo to next message
Littlefoot
Messages: 18821
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Run the form in debug mode.
Re: Find an error line in PLSql [message #589093 is a reply to message #589092] Tue, 02 July 2013 03:22 Go to previous messageGo to next message
kolpalamayaw
Messages: 7
Registered: May 2013
Location: TURKEY
Junior Member
Actually, I found the line but I couldn't analyse it. When I run it, system give an error like 'V_yer=2'
I just want to know that does sql run between v_yer=1 and v_yer=2 codes or not?
Re: Find an error line in PLSql [message #589095 is a reply to message #589093] Tue, 02 July 2013 03:24 Go to previous messageGo to next message
Littlefoot
Messages: 18821
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
v_yer = 2
is an invalid PL/SQL statement (should be :=), so form processing stops there.
Re: Find an error line in PLSql [message #589100 is a reply to message #589095] Tue, 02 July 2013 03:40 Go to previous message
kolpalamayaw
Messages: 7
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
Previous Topic: wrong number or types of arguments in call to function
Next Topic: forms -alert
Goto Forum:
  


Current Time: Wed Apr 16 09:32:49 CDT 2014

Total time taken to generate the page: 0.05809 seconds