SYS.DBMS_DEBUG dependencies on DBMS_DEBUG_VC2COLL

Line 1355: -- coll sys.dbms_debug_vc2coll; -- results (unused)

1351: --
1352: -- SAMPLE USE:
1353: -- 1. SQL:
1354: -- DECLARE
1355: -- coll sys.dbms_debug_vc2coll; -- results (unused)
1356: -- errm VARCHAR2(100);
1357: -- BEGIN
1358: -- dbms_debug.execute('insert into emp(ename,empno,deptno) ' ||
1359: -- 'values(''LJE'', 1, 1)',

Line 1372: -- coll sys.dbms_debug_vc2coll; -- results (unused)

1368: -- character).
1369: --
1370: -- 2. PL/SQL (with autonomous transaction):
1371: -- DECLARE
1372: -- coll sys.dbms_debug_vc2coll; -- results (unused)
1373: -- errm VARCHAR2(100);
1374: -- BEGIN
1375: -- dbms_debug.execute(
1376: -- 'DECLARE PRAGMA autonomous_transaction; ' ||

Line 1387: -- my_vc2coll sys.dbms_debug_vc2coll;

1383: -- END;
1384: --
1385: -- 3. PL/SQL (with results)
1386: -- DECLARE
1387: -- my_vc2coll sys.dbms_debug_vc2coll;
1388: -- errm VARCHAR2(100);
1389: -- each PLS_INTEGER;
1390: -- BEGIN
1391: -- dbms_debug.execute(

Line 1393: -- ' vc SYS.dbms_debug_vc2coll := ' ||

1389: -- each PLS_INTEGER;
1390: -- BEGIN
1391: -- dbms_debug.execute(
1392: -- 'DECLARE ' ||
1393: -- ' vc SYS.dbms_debug_vc2coll := ' ||
1394: -- ' SYS.dbms_debug_vc2coll();' ||
1395: -- ' len PLS_INTEGER; ' ||
1396: -- ' i PLS_INTEGER := 1; ' ||
1397: -- 'BEGIN ' ||

Line 1394: -- ' SYS.dbms_debug_vc2coll();' ||

1390: -- BEGIN
1391: -- dbms_debug.execute(
1392: -- 'DECLARE ' ||
1393: -- ' vc SYS.dbms_debug_vc2coll := ' ||
1394: -- ' SYS.dbms_debug_vc2coll();' ||
1395: -- ' len PLS_INTEGER; ' ||
1396: -- ' i PLS_INTEGER := 1; ' ||
1397: -- 'BEGIN ' ||
1398: -- ' SELECT COUNT(*) INTO len FROM emp; ' ||

Line 1424: results IN OUT NOCOPY dbms_debug_vc2coll,

1420: --
1421: PROCEDURE execute(what IN VARCHAR2,
1422: frame# IN BINARY_INTEGER,
1423: bind_results IN BINARY_INTEGER,
1424: results IN OUT NOCOPY dbms_debug_vc2coll,
1425: errm IN OUT NOCOPY VARCHAR2);
1426:
1427:
1428: ------------------------ TARGET_PROGRAM_RUNNING ------------------------