Search the Reference Library pages:  

Oracle DBMS_SQLPLUS_SCRIPT
Version 11.1
 
General
Note: Undocumented
Source $ORACLE_HOME/rdbms/admin/prvtscrp.plb
Dependencies
DBMS_SQLPLUS_SCRIPT_LIB
Data Types DBMS_SQLPLUS_SCRIPT.STMT_RECORD
DBMS_SQLPLUS_SCRIPT.BIND_RECORD
DBMS_SQLPLUS_SCRIPT.STMT_TABLE
DBMS_SQLPLUS_SCRIPT.BIND_TABLE
 
PARSE

Undocumented
dbms_sqlplus_script.parse(
src       IN  CLOB,
stmts     OUT PL/SQL TABLE); 
set serveroutput on

DECLARE
 srcclob CLOB;
 stmts   dbms_sqlplus_script.stmt_table;
BEGIN
  srcclob := CAST('BEGIN
INSERT INTO WORKSTATIONS VALUES (11,3,20037,'''',''Y'',61.137,-149.9395,''10.128.16.105'');
INSERT INTO WORKSTATIONS VALUES (11,5,20044,'''',''Y'',61.137,-149.9395,''10.128.32.129'');
COMMIT;
INSERT INTO WORKSTATIONS VALUES
(11,9,20048,'''',''Y'',61.137,-149.9395,''10.128.32.169'');
INSERT INTO WORKSTATIONS VALUES (12,1,20051,''15706'',''Y'',32.75604,-117.1201,'''');
INSERT INTO WORKSTATIONS VALUES (12,102,20057,'''',''Y'',32.75677,-117.1241,''10.129.112.25'');
INSERT INTO WORKSTATIONS VALUE (12,103,20058,'''',''Y'',32.75662,-117.124,''10.129.112.33'');
COMMIT;
END;' AS CLOB);


  dbms_sqlplus_script.parse(srcclob, stmts=>stmts);
  dbms_output.put_line(stmts.COUNT);
END;
/
 
 
   Home |    Search |    Code Library |    Sponsors |    Privacy |    Terms of Use |    Contact Us    © 2003 - 2024 psoug.org
-----