rem load_pl.bat loads country_state.xml into Oracle database via PL/SQL via two parameters of username and password RJM Programming 2013
if %1TRICK==TRICK goto nomore
if %2TRICK==TRICK goto nomore

echo CREATE TABLE country_state_xml_pl OF XMLType; > load_pl.sql
echo CREATE DIRECTORY temp AS 'c:\temp'; >> load_pl.sql
echo GRANT all on DIRECTORY temp to xdb; >> load_pl.sql
echo exit >> load_pl.sql
sqlplus %1/%2 @load_pl.sql

echo declare > loadpl.sql
echo    myres boolean; >> loadpl.sql
echo begin >> loadpl.sql
echo   myres := dbms_xdb.createFolder('/home/demo'); >> loadpl.sql
echo   myres := dbms_xdb.createResource('/home/demo/country_state.xml', bfilename('TEMP', 'country_state.xml'), >> loadpl.sql
echo                          nls_charset_id('AL32UTF8')); >> loadpl.sql
echo   end; >> loadpl.sql
echo / >> loadpl.sql
echo exit >> loadpl.sql
sqlplus %1/%2 @loadpl.sql

echo SELECT sys.UriFactory.getUri('/home/demo/country_state.xml').getclob() from dual; > select_pl.sql
echo exit >> select_pl.sql
sqlplus %1/%2 @select_pl.sql

goto fin
:nomore
echo Need username and password to login to Oracle sqlplus and sqlldr
:fin