Home » SQL & PL/SQL » SQL & PL/SQL » Date issue
Date issue [message #392463] Wed, 18 March 2009 02:01 Go to next message
eddylsk
Messages: 3
Registered: March 2009
Junior Member
Hi all,

I'm newbie here. Recently when I try to execute the following package, i encountered the following issue:

The following error has occurred:

ORA-06550: line 3, column 24: PLS-00103: Encountered the symbol "DATE" when expecting one of

the following:

:= . ( @ % ; not null range default character
The symbol ":=" was substituted for "DATE" to continue.

This is my code:
DECLARE 
		v_case_id	 		   	varchar2(25);
		v_datetime_ creation	DATE NOT NULL := sysdate;
		v_err_msg				varchar2(255);
		v_result				varchar2(10);
		
BEGIN 
	 	pkg_cmss_ext_mvno.sp_mvno_case('60124742020',	 --p_dir_no
									'982813412',		 --p_bill_acct_no
									'testuser',			 --p_user_id
									'Test Notes',		 --p_notes
									'Fixed-Centrex',	 --'Please Select',	 --p_product
									'Complaint',		 --'Please Select',	 --p_reason1
									'Bill-Wrong address',--'Please Select',	 --p_reason2
									'Incorrect address', --'Please Select',	 --p_reason3
									sysdate,   			 --p_occur_time
									'S-1234-01',		 --p_service_code
									'E-1234',			 --p_entity_code
									v_case_id,			 --p_case_id	 	 	OUT
									v_datetime_creation, --p_datetime_creation	OUT
									v_err_msg,			 --p_err_msg			OUT
									v_result			 --p_result				OUT
									);
		DBMS_OUTPUT.PUT_LINE('Case ID:' || v_case_id);
				DBMS_OUTPUT.PUT_LINE('ERROR CODE: ' || v_result);
		DBMS_OUTPUT.PUT_LINE('ERROR MESSAGE:' || v_err_msg);
END;	

Any help will be appreciated. Thanks.


[mod-edit] color removed - added code tags (although it didn't make it any easier to read).

[Updated on: Wed, 18 March 2009 08:14] by Moderator

Report message to a moderator

Re: Date issue [message #392466 is a reply to message #392463] Wed, 18 March 2009 02:06 Go to previous messageGo to next message
Frank
Messages: 7880
Registered: March 2000
Senior Member
There's a space in your variable name on line 3.
Also NOT NULL is reserved for table columns, not for variables in PL/SQL
Re: Date issue [message #392470 is a reply to message #392466] Wed, 18 March 2009 02:20 Go to previous messageGo to next message
eddylsk
Messages: 3
Registered: March 2009
Junior Member
Frank wrote on Wed, 18 March 2009 15:06
There's a space in your variable name on line 3.
Also NOT NULL is reserved for table columns, not for variables in PL/SQL


Thanks Frank for the help and tips. It works now.
Re: Date issue [message #392471 is a reply to message #392463] Wed, 18 March 2009 02:22 Go to previous messageGo to next message
Michel Cadot
Messages: 64132
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Frank has pretty good eyes (for extra space) but it should be obvious if you had posted following the OraFAQ Forum Guide, especially "How to format your post?" section and use code tags.

Regards
Michel
Re: Date issue [message #392689 is a reply to message #392471] Wed, 18 March 2009 22:38 Go to previous message
eddylsk
Messages: 3
Registered: March 2009
Junior Member
Thanks Michel.
Previous Topic: Audit triggers (merged 4)
Next Topic: Timezone issue with the date field
Goto Forum:
  


Current Time: Thu Dec 08 00:20:41 CST 2016

Total time taken to generate the page: 0.11440 seconds