SQLPLUS and Windows Batch Files

[pseit01]

I am looking for an example of how to capture a return code from within a Windows Batch (.bat) file that executes a SQLPLUS command. The SQL script will either exit with EXIT(0) or EXIT(n). If the exit is greater than ZERO, then the .BAT file will need to perform additional logic

[fhkhan78]

I am looking for an example of how to capture a return code from within a Windows Batch (.bat) file that executes a SQLPLUS command. The SQL script will either exit with EXIT(0) or EXIT(n). If the exit is greater than ZERO, then the .BAT file will need to perform additional logic

simply right click on the batch file and click on edit the file will be open in the note pad

[kbilal]

Use host command to execute the batch file like the example given below:

host(abc.bat);

[Orawonster]

%ERRORLEVEL% might be what you want to look into

[subashsavji]

I am looking for an example of how to capture a return code from within a Windows Batch (.bat) file that executes a SQLPLUS command. The SQL script will either exit with EXIT(0) or EXIT(n). If the exit is greater than ZERO, then the .BAT file will need to perform additional logic

this may be useful to you..

PROCEDURE rcv_data IS
h9 varchar2(1200);
fnd varchar2(1);
fr number;
lr number;

BEGIN
fr:=0;
lr:=0;

H9:='imp80 CORE/CORE@ibm tables=(ct_tcv_indent_bk,ct_tcv_bk,ct_tcv_ind_loca l_bk) file='||:FILE_NAME;
MESSAGE(H9);
MESSAGE(H9);
host(h9);

SELECT 'X' INTO FND FROM USER_TABLES WHERE TABLE_NAME='CT_TCV_INDENT_BK';

select count(*) into fr from CT_TCV_INDENT;

IF SQL%NOTFOUND THEN
MESSAGE('ERROR - 9898 NOT IMPORTED ');
ELSE

MESSAGE('IMPORTED ');
INSERT INTO CT_TCV SELECT * FROM CT_TCV_BK WHERE (AC_YEAR_CODE,TCS_TCS_NO,TCS_TCS_DATE,TRIP_BRANCH_ BRANCH_CODE)
commit;
end if;

END;