Home » Developer & Programmer » Forms » ERROR 103 (cant see what was wrong) (oracle 10g, windows 7)
ERROR 103 (cant see what was wrong) [message #577056] Tue, 12 February 2013 02:57 Go to next message
needs2lern
Messages: 14
Registered: January 2013
Location: Philippines
Junior Member
i really dont know whats wrong with this.... help please.. tnx in advance


error 103 at line 23, column 37
Encountered the symbol "=" when expecting one of the following:

:=.(@%; indicator




Declare 
	n NUMBER;
	
BEGIN
	
	set_alert_property ('ALERT_CHOOSE', alert_message_text, 'Please choose a Division');
	set_alert_button_property ('ALERT_CHOOSE', alert_button1, label, 'OK');
	n := show_alert ('ALERT_CHOOSE');
	
	if n = alert_button1 then
	go_item('list_of_divisions');
	
	BEGIN 
		IF :DIVISIONS.LIST_OF_DIVISIONS = 'Systems Management Division' THEn
		 	call_form ('C:\nomb\SMDSCHED.fmx');
		 				 				
		ELSIF :DIVISIONS.LIST_OF_DIVISIONS = 'ICT Planning & Standards Division' THEn
		 	call_form ('C:\nomb\ICTSCHED.fmx');
	
		ELSIF :DIVISIONS.LIST_OF_DIVISIONS = 'Knowledge Management Division' THEn
		 	call_form ('C:\nomb\KMDSCHED.fmx');
				
		ELSE :DIVISIONS.LIST_OF_DIVISIONS = 'Network Operations & Management Division' THEN
				call_form('c:\nomb\NOMDSCHED.fmx');
  
END;



[Updated on: Tue, 12 February 2013 02:58]

Report message to a moderator

Re: ERROR 103 (cant see what was wrong) [message #577059 is a reply to message #577056] Tue, 12 February 2013 02:58 Go to previous messageGo to next message
Michel Cadot
Messages: 68641
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Which line is line 23?

Regards
Michel
Re: ERROR 103 (cant see what was wrong) [message #577061 is a reply to message #577059] Tue, 12 February 2013 03:00 Go to previous messageGo to next message
needs2lern
Messages: 14
Registered: January 2013
Location: Philippines
Junior Member
the cursor shows up at these line...
	
ELSE :DIVISIONS.LIST_OF_DIVISIONS = 'Network Operations & Management Division' THEN
				call_form('c:\nomb\NOMDSCHED.fmx');
Re: ERROR 103 (cant see what was wrong) [message #577063 is a reply to message #577061] Tue, 12 February 2013 03:01 Go to previous messageGo to next message
needs2lern
Messages: 14
Registered: January 2013
Location: Philippines
Junior Member
between ":DIVISIONS.LIST_OF_DIVISIONS" and "="
Re: ERROR 103 (cant see what was wrong) [message #577064 is a reply to message #577061] Tue, 12 February 2013 03:01 Go to previous messageGo to next message
Michel Cadot
Messages: 68641
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Does not ELSE should be ELSIF?

Regards
Michel
Re: ERROR 103 (cant see what was wrong) [message #577065 is a reply to message #577064] Tue, 12 February 2013 03:04 Go to previous messageGo to next message
needs2lern
Messages: 14
Registered: January 2013
Location: Philippines
Junior Member
error 103 at line 26, column 4
Encountered the symbol ";" when expecting one of the following"

if
Re: ERROR 103 (cant see what was wrong) [message #577067 is a reply to message #577065] Tue, 12 February 2013 03:04 Go to previous messageGo to next message
needs2lern
Messages: 14
Registered: January 2013
Location: Philippines
Junior Member
the cursor shows up at "end;" syntax
Re: ERROR 103 (cant see what was wrong) [message #577073 is a reply to message #577067] Tue, 12 February 2013 03:10 Go to previous messageGo to next message
Michel Cadot
Messages: 68641
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
The last ELSE/ELSIF part must be followed by and "END IF;" to end the "IF".

Regards
Michel
Re: ERROR 103 (cant see what was wrong) [message #577587 is a reply to message #577073] Mon, 18 February 2013 19:43 Go to previous messageGo to next message
needs2lern
Messages: 14
Registered: January 2013
Location: Philippines
Junior Member
sorry for the late response sir,, now i am continuing my project and still got the same error,. Sad
Re: ERROR 103 (cant see what was wrong) [message #577597 is a reply to message #577587] Tue, 19 February 2013 00:51 Go to previous message
Littlefoot
Messages: 21807
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Could you post the latest version of your code?
Previous Topic: report not run
Next Topic: insert by cursor
Goto Forum:
  


Current Time: Thu Apr 18 22:49:56 CDT 2024