Date issue [message #392463] |
Wed, 18 March 2009 02:01  |
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   |
Frank
Messages: 7901 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   |
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.
|
|
|
|
|