1: PACKAGE BODY DBMS_XMLQUERY AS
2:
3: procedure getVersion IS
4: begin
5: DBMS_OUTPUT.PUT_LINE(CHR(0));
6: DBMS_OUTPUT.PUT_LINE(CHR(0));
7: DBMS_OUTPUT.PUT_LINE('XSU Version ' ||
8: 'Owner Timestamp');
9: DBMS_OUTPUT.PUT_LINE('-------------------------- ' ||
2:
3: procedure getVersion IS
4: begin
5: DBMS_OUTPUT.PUT_LINE(CHR(0));
6: DBMS_OUTPUT.PUT_LINE(CHR(0));
7: DBMS_OUTPUT.PUT_LINE('XSU Version ' ||
8: 'Owner Timestamp');
9: DBMS_OUTPUT.PUT_LINE('-------------------------- ' ||
10: '------------- ----------------');
3: procedure getVersion IS
4: begin
5: DBMS_OUTPUT.PUT_LINE(CHR(0));
6: DBMS_OUTPUT.PUT_LINE(CHR(0));
7: DBMS_OUTPUT.PUT_LINE('XSU Version ' ||
8: 'Owner Timestamp');
9: DBMS_OUTPUT.PUT_LINE('-------------------------- ' ||
10: '------------- ----------------');
11:
5: DBMS_OUTPUT.PUT_LINE(CHR(0));
6: DBMS_OUTPUT.PUT_LINE(CHR(0));
7: DBMS_OUTPUT.PUT_LINE('XSU Version ' ||
8: 'Owner Timestamp');
9: DBMS_OUTPUT.PUT_LINE('-------------------------- ' ||
10: '------------- ----------------');
11:
12: FOR i IN (select object_name, owner, timestamp
13: from all_objects
12: FOR i IN (select object_name, owner, timestamp
13: from all_objects
14: where object_name like '%XSU%VERSION%')
15: LOOP
16: DBMS_OUTPUT.PUT_LINE(RPAD(i.object_name,27) ||
17: RPAD(i.owner,14) || SUBSTR(i.timestamp,1,16));
18: END LOOP;
19: DBMS_OUTPUT.NEW_LINE;
20: end getVersion;
15: LOOP
16: DBMS_OUTPUT.PUT_LINE(RPAD(i.object_name,27) ||
17: RPAD(i.owner,14) || SUBSTR(i.timestamp,1,16));
18: END LOOP;
19: DBMS_OUTPUT.NEW_LINE;
20: end getVersion;
21:
22: FUNCTION newContext(sqlQuery IN VARCHAR2) return ctxType
23: as LANGUAGE JAVA NAME