SQL>
SQL> set serveroutput on
SQL>
SQL> CREATE OR REPLACE PROCEDURE Tokenize(name IN VARCHAR2) AS
2 v_A VARCHAR2(256);
3 v_B VARCHAR2(256);
4 v_C VARCHAR2(256);
5 v_DBLink VARCHAR2(256);
6 v_NextPos BINARY_INTEGER;
7 BEGIN
8 DBMS_UTILITY.NAME_TOKENIZE(name, v_A, v_B, v_C, v_DBLink,
9 v_NextPos);
10 DBMS_OUTPUT.PUT_LINE('a: ' || v_A);
11 DBMS_OUTPUT.PUT_LINE('b: ' || v_B);
12 DBMS_OUTPUT.PUT_LINE('c: ' || v_C);
13 DBMS_OUTPUT.PUT_LINE('db link: ' || v_DBLink);
14 DBMS_OUTPUT.PUT_LINE('next pos: ' || v_NextPos);
15 END Tokenize;
16 /
Procedure created.
SQL>
SQL> exec Tokenize('example.lecturer');
a: EXAMPLE
b: LECTURER
c:
db link:
next pos: 16
PL/SQL procedure successfully completed.