I am trying to write a procedure for adding records to my oracle 8i db. I keep getting 2 errors
CODE
Error 1 PLS-00382: expression is of wrong type ORACLE://rjl05.ORADEV01/Procedure/RJL05/ADD_BHIP_TRK_ITEM[CODE]* 79 1
and
Error 2 PL/SQL: SQL Statement ignored ORACLE://rjl05.ORADEV01/Procedure/RJL05/ADD_BHIP_TRK_ITEM[CODE]* 32 1
the first error is referring to the item v_TRACK_LOG at the bottom of the code and the second error is ignoring Insert into BHIP_TRACK. I have never wrote a oracle procedure before and not sure what to do. My procedure code in below any help would be greatly appreciated
CODE
PROCEDURE "RJL05".ADD_BHIP_TRK_ITEM(
v_TRACKNO IN NUMBER,
v_TRACKTYPE IN CHAR,
v_RESPONDENT_LNAME IN VARCHAR2,
v_RESPONDENT_FNAME IN VARCHAR2,
v_RESPONDENT_MI IN CHAR,
v_PROF_DESIG IN CHAR,
v_RESPONDENT_STREET IN VARCHAR2,
v_RESPONDENT_CITY IN VARCHAR2,
v_RESPONDENT_STATE IN CHAR,
v_RESPONDENT_ZIP IN VARCHAR2,
v_BUSINESS_ENTITY IN VARCHAR2,
v_REFERRAL_DATE IN DATE,
v_COMPLETE_DATE IN DATE,
v_CORRESPONDDATE IN DATE,
v_ATTORNEY_CODE IN CHAR,
v_ASSIGNED_DATE IN DATE,
v_PROGRAM_NO IN CHAR,
v_PROGRAM_AREA IN CHAR,
v_RETURN_DATE IN DATE,
v_ACTION_TYPE IN CHAR,
v_TRACK_LOG IN CLOB,
v_CREATE_DATE IN DATE,
v_CLOSED_DATE IN DATE,
v_UPDATE_DATE IN DATE,
v_UPDATE_BY IN CHAR)
IS
BEGIN
Insert into BHIP_TRACK
(TRACKNO,
TRACKTYPE,
RESPONDENT_LNAME,
RESPONDENT_FNAME,
RESPONDENT_MI,
PROF_DESIG,
RESPONDENT_STREET,
RESPONDENT_CITY,
RESPONDENT_STATE,
RESPONDENT_ZIP,
BUSINESS_ENTITY,
REFERRAL_DATE,
COMPLETE_DATE,
CORRESPONDDATE,
ATTORNEY_CODE,
ASSIGNED_DATE,
PROGRAM_NO,
PROGRAM_AREA,
RETURN_DATE,
ACTION_TYPE,
TRACK_LOG,
CREATE_DATE,
CLOSED_DATE,
UPDATE_DATE,
UPDATE_BY)
Values(
v_TRACKNO,
v_TRACKTYPE,
v_RESPONDENT_LNAME,
v_RESPONDENT_FNAME,
v_PROF_DESIG,
v_RESPONDENT_STREET,
v_RESPONDENT_CITY,
v_RESPONDENT_STATE,
v_RESPONDENT_ZIP,
v_BUSINESS_ENTITY,
v_REFERRAL_DATE,
v_COMPLETE_DATE,
v_CORRESPONDDATE,
v_ATTORNEY_CODE,
v_ASSIGNED_DATE,
v_PROGRAM_NO,
v_PROGRAM_AREA,
v_RETURN_DATE,
v_ACTION_TYPE,
v_TRACK_LOG,
v_CREATE_DATE,
v_CLOSED_DATE,
v_UPDATE_DATE,
v_UPDATE_BY);
COMMIT;
END ADD_BHIP_TRK_ITEM;
| 