ORA-00488: RBAL process terminated with error
Although we try to provide custom solutions, we do not have a solution yet for all Oracle Error Messages. We apologize for that. You can use the feedback part to indicate this was not helpfull and we'll try to prioritize the creation of a satisfying solution.
*Action: Warm start instance.
Welcome to our forum for Oracle error: ORA-00488 Add your own message
cannot figure this error out
SET SERVEROUTPUT ON
--VARIABLE G_NAME_OUT VARCHAR2(40)
ACCEPT p_sfirst PROMPT 'Please enter your first name:'
accept p_slast prompt 'Please enter your last name: '
accept p_sid prompt 'Please enter your student ID: '
accept p_spin prompt 'Please enter your student pin: '
accept p_sdob prompt 'Please enter your date of birth MON-DD-YYYY: '
declare
v_student_fullname varchar2(40);
v_student_firstname student.s_first%TYPE;
v_student_lastname student.s_last%TYPE;
v_sid student.s_id%TYPE:=&p_sid;
v_spin student.s_pin%TYPE:=&p_spin;
v_student_dob TO_DATE('mon-dd-yyyy');
v_sdob student.s_dob%TYPE;
begin
select s_first,s_last,s_id,s_pin,s_dob
into v_student_firstname, v_student_lastname,v_sid,v_spin,v_sdob
from student
where s_id=v_sid;
v_student_fullname:=v_student_firstname||v_student_lastname;
DBMS_OUTPUT.PUT_LINE('Student'||v_sid||'is'||v_student_fullname);
end;
Error report:
ORA-06550: line 7, column 15:
PLS-00488: invalid variable declaration: object 'TO_DATE' must be a type or subtype
ORA-06550: line 7, column 15:
PL/SQL: Item ignored
The defintion of the following is incorrect.
v_student_dob TO_DATE('mon-dd-yyyy');
There is no such datatype as to_date. It is just a function to translate a string into a date.
eg. select to_date('01-jan-2010', 'dd-mon-yyyy') from dual;
You just need to define the v_student_dob variable as a date datatype:
v_student_dob date;
Or base it on a column type:
v_student_dob student.dob%TYPE;
Add your message
If you need more information about this particular error message, you can leave a forum message.
We are replying to this message whenever we have some spare time, so please do not consider this as a private 'solve my critical issue asap' service.
Should you need professional Oracle Assistance to make your project a success, please have a look at our consultancy services.
In order to prevent automatic generation of messages, we are asking for a validation code. This code is unique and is generated every time a new message is asked.
If you do not enter the validation correctly, your message will not be recorded.