Home » SQL & PL/SQL » SQL & PL/SQL » please any one help me
please any one help me [message #39454] |
Wed, 17 July 2002 15:24 |
rashme
Messages: 7 Registered: July 2002
|
Junior Member |
|
|
DECLARE
V_INFILEHANDLE UTL_FILE.FILE_TYPE;
V_MYBUFFER VARCHAR(2000);
V_ID VARCHAR2(20);
V_FNAME VARCHAR2(20);
V_LNAME VARCHAR2(20);
V_FIELD VARCHAR2(20);
V_SAL NUMBER;
V_DEPT NUMBER;
BEGIN
V_INFILEHANDLE := UTL_FILE.FOPEN('C:','INFORMATION.TXT','R');
LOOP
BEGIN
UTL_FILE.GET_LINE(V_INFILEHANDLE,V_MYBUFFER);
V_ID := SUBSTR(V_MYBUFFER,1, INSTR(V_MYBUFFER,',')-1);
V_FNAME := SUBSTR(V_MYBUFFER, INSTR(V_MYBUFFER,',', 1)+1, INSTR(V_MYBUFFER,',',1,2)-1);
V_LNAME := SUBSTR(V_MYBUFFER, INSTR(V_MYBUFFER,',' ,1,2)+1, INSTR(V_MYBUFFER,',',1,3)-1);
V_FIELD := SUBSTR(V_MYBUFFER, INSTR(V_MYBUFFER,',', 1,3)+1, INSTR(V_MYBUFFER,',',1,4)-1);
V_SAL := SUBSTR(V_MYBUFFER, INSTR(V_MYBUFFER,',', 1,4)+1, INSTR(V_MYBUFFER,',',1,5)-1);
V_FNAME := SUBSTR(V_MYBUFFER, INSTR(V_MYBUFFER,',', 1,5)+1, LENGTH(V_MYBUFFER));
INSERT INTO DETAILS (ID,FNAME,LNAME,FIELD,SAL,DEPT_ID)
VALUES(V_ID,V_FNAME,V_LNAME,V_FIELD,V_SAL,V_DEPT);
EXCEPTION
WHEN NO_DATA_FOUND THEN
DBMS_OUTPUT.PUT_LINE('no_data_found');
EXIT;
END;
END LOOP;
UTL_FILE.FCLOSE(V_INFILEHANDLE);
END;
when iam excecuting this iam getting this error
ERROR at line 1:
ORA-06510: PL/SQL: unhandled user-defined exception
ORA-06512: at "SYS.UTL_FILE", line 120
ORA-06512: at "SYS.UTL_FILE", line 204
ORA-06512: at line 11
thanks in advance
rashme
|
|
|
|
Goto Forum:
Current Time: Fri Apr 26 22:29:26 CDT 2024
|