SYS.DBMS_SQLTUNE_UTIL2 dependencies on SQL_BINDS

Line 47: --------------------------- sql_binds_ntab_to_varray ------------------------

43: begin_snap IN NUMBER,
44: end_snap IN NUMBER,
45: incl_bid IN BOOLEAN := FALSE);
46:
47: --------------------------- sql_binds_ntab_to_varray ------------------------
48: -- NAME:
49: -- sql_binds_ntab_to_varray
50: --
51: -- DESCRIPTION:

Line 49: -- sql_binds_ntab_to_varray

45: incl_bid IN BOOLEAN := FALSE);
46:
47: --------------------------- sql_binds_ntab_to_varray ------------------------
48: -- NAME:
49: -- sql_binds_ntab_to_varray
50: --
51: -- DESCRIPTION:
52: -- This function converts the sql binds data from the nested table stored
53: -- in the staging table on an unpack/pack to the varray type used in the

Line 52: -- This function converts the sql binds data from the nested table stored

48: -- NAME:
49: -- sql_binds_ntab_to_varray
50: --
51: -- DESCRIPTION:
52: -- This function converts the sql binds data from the nested table stored
53: -- in the staging table on an unpack/pack to the varray type used in the
54: -- SQLSET_ROW. It is called by the unpack_stgtab_sqlset function since it
55: -- needs to pass binds as a VARRAY to the load_sqlset function
56: --

Line 59: -- sql_binds nested table type

55: -- needs to pass binds as a VARRAY to the load_sqlset function
56: --
57: -- PARAMETERS:
58: -- binds_nt (IN) - list of binds for a single statement, in the
59: -- sql_binds nested table type
60: --
61: -- RETURN:
62: -- Corresponding varray type (sql_binds_varray) to the input, which is
63: -- an ordered list of bind values, of type ANYDATA.

Line 62: -- Corresponding varray type (sql_binds_varray) to the input, which is

58: -- binds_nt (IN) - list of binds for a single statement, in the
59: -- sql_binds nested table type
60: --
61: -- RETURN:
62: -- Corresponding varray type (sql_binds_varray) to the input, which is
63: -- an ordered list of bind values, of type ANYDATA.
64: -- If given null as input this function returns null.
65: --
66: -----------------------------------------------------------------------------

Line 67: FUNCTION sql_binds_ntab_to_varray(binds_ntab IN SQL_BIND_SET)

63: -- an ordered list of bind values, of type ANYDATA.
64: -- If given null as input this function returns null.
65: --
66: -----------------------------------------------------------------------------
67: FUNCTION sql_binds_ntab_to_varray(binds_ntab IN SQL_BIND_SET)
68: RETURN SQL_BINDS;
69:
70: ------------------------- sql_binds_varray_to_ntab -------------------------
71: -- NAME:

Line 68: RETURN SQL_BINDS;

64: -- If given null as input this function returns null.
65: --
66: -----------------------------------------------------------------------------
67: FUNCTION sql_binds_ntab_to_varray(binds_ntab IN SQL_BIND_SET)
68: RETURN SQL_BINDS;
69:
70: ------------------------- sql_binds_varray_to_ntab -------------------------
71: -- NAME:
72: -- sql_binds_varray_to_ntab

Line 70: ------------------------- sql_binds_varray_to_ntab -------------------------

66: -----------------------------------------------------------------------------
67: FUNCTION sql_binds_ntab_to_varray(binds_ntab IN SQL_BIND_SET)
68: RETURN SQL_BINDS;
69:
70: ------------------------- sql_binds_varray_to_ntab -------------------------
71: -- NAME:
72: -- sql_binds_varray_to_ntab
73: --
74: -- DESCRIPTION:

Line 72: -- sql_binds_varray_to_ntab

68: RETURN SQL_BINDS;
69:
70: ------------------------- sql_binds_varray_to_ntab -------------------------
71: -- NAME:
72: -- sql_binds_varray_to_ntab
73: --
74: -- DESCRIPTION:
75: -- This function converts the sql binds data from a VARRAY as it exists
76: -- in SQLSET_ROW into a nested table that can be stored in the staging

Line 75: -- This function converts the sql binds data from a VARRAY as it exists

71: -- NAME:
72: -- sql_binds_varray_to_ntab
73: --
74: -- DESCRIPTION:
75: -- This function converts the sql binds data from a VARRAY as it exists
76: -- in SQLSET_ROW into a nested table that can be stored in the staging
77: -- table.
78: -- It is called by pack_stgtab_sqlset as it inserts into the staging
79: -- table from the output of a call to select_sqlset.

Line 83: -- sql_binds VARRAY type

79: -- table from the output of a call to select_sqlset.
80: --
81: -- PARAMETERS:
82: -- binds_varray (IN) - list of binds for a single statement, in the
83: -- sql_binds VARRAY type
84: --
85: -- RETURN:
86: -- Corresponding nested table type (sql_bind_set) to the input, which is
87: -- a list of (position, value) pairs for the information in STMT_BINDS.

Line 91: FUNCTION sql_binds_varray_to_ntab(binds_varray IN SQL_BINDS)

87: -- a list of (position, value) pairs for the information in STMT_BINDS.
88: -- If given null as input this function returns null.
89: --
90: -----------------------------------------------------------------------------
91: FUNCTION sql_binds_varray_to_ntab(binds_varray IN SQL_BINDS)
92: RETURN SQL_BIND_SET;
93:
94: ----------------------------------- check_priv ------------------------------
95: -- NAME: