1 PACKAGE inv_sql_binding_pvt AS
2 /* $Header: INVVSQBS.pls 120.1 2005/06/11 07:36:57 appldev $ */
3 --
4 -- File : INVVSQBS.pls
5 -- Content : INV_SQL_BINDING_PVT package spec
6 -- Description : Procedures and functions used for sql binding.
7 -- This package gives you a way to manage your bind
8 -- variables by registering them with the package
9 -- and get a indentifier which you can use in
10 -- your dynamic sql, and call the procedure bindvars
11 -- to bind all variables to the cursor passed in.
12 --
13 -- Notes :
14 -- Modified : 10/22/1999 bitang created
15 --
16 --
17 -- API name : InitBindTables
18 -- Type : Private
19 -- Function : Initializes internal tables of bind variable names and their
20 -- values. Needed for dynamic SQL.
21 -- Pre-reqs : none
22 -- Parameters : none
23 -- Version : not tracked
24 -- Notes :
25 PROCEDURE InitBindTables;
26 --
27 -- API name : SaveBindPointers
28 -- Type : Private
29 -- Function : Saves pointers to current bind variable tables rows.
30 -- Needed to distinguish between 'static' and 'dynamic'
31 -- entry sections according to implemented algorithm??
32 -- Pre-reqs : none
33 -- Parameters : none
34 -- Version : not tracked
35 -- Notes :
36 --
37 PROCEDURE SaveBindPointers;
38 --
39 -- API name : RestoreBindPointers
40 -- Type : Private
41 -- Function : Restores pointers to specific bind variable tables rows.
42 -- Needed to reuse 'static' and overwrite 'dynamic'
43 -- entry sections according to implemented algorithm.
44 -- Pre-reqs : none
45 -- Parameters : none
46 -- Version : not tracked
47 -- Notes :
48 --
49 PROCEDURE RestoreBindPointers;
50 --
51 -- API name : InitBindVar
52 -- Type : Private
53 -- Function : Adds an entry to the corresponding bind variable table
54 -- and stores created name as well as value, returns name.
55 -- Pre-reqs : none
56 -- Parameters :
57 -- p_value in number required
58 -- OR
59 -- p_value in varchar2 required
60 -- OR
61 -- p_value in date required
62 -- return value OUT NOCOPY /* file.sql.39 change */ varchar2(10)
63 -- Version : not tracked
64 -- Notes : Overlayed functions for each supported data type
65 --
66 FUNCTION InitBindVar ( p_value IN NUMBER ) RETURN VARCHAR2;
67 --
68 FUNCTION InitBindVar ( p_value IN VARCHAR2 ) RETURN VARCHAR2;
69 --
70 FUNCTION InitBindVar ( p_value IN DATE ) RETURN VARCHAR2;
71 --
72 -- API name : BindVars
73 -- Type : Private
74 -- Function : Binds all variables stored in the internal bind variable
75 -- tables to the given dynamic SQL cursor.
76 -- Pre-reqs : refer to dbms_sql package spec
77 -- Parameters :
78 -- p_cursor in integer required
79 -- Version : not tracked
80 -- Notes :
81 PROCEDURE BindVars ( p_cursor IN INTEGER );
82 --
83 -- API name : GetConversionString
84 -- Type : Private
85 -- Function : Returns SQL conversion function syntax corresponding to the
86 -- given data types to convert.
87 -- Pre-reqs : none
88 -- Parameters :
89 -- p_data_type_code in number required
90 -- p_parent_data_type_code in number required
91 -- x_left_part_conv_fct OUT NOCOPY /* file.sql.39 change */ varchar2(20)
92 -- x_right_part_conv_fct OUT NOCOPY /* file.sql.39 change */ varchar2(20)
93 -- Version : not tracked
94 -- Notes : needed to be verified
95 PROCEDURE GetConversionString
96 ( p_data_type_code IN NUMBER
97 ,p_parent_data_type_code IN NUMBER
98 ,x_left_part_conv_fct OUT NOCOPY /* file.sql.39 change */ VARCHAR2
99 ,x_right_part_conv_fct OUT NOCOPY /* file.sql.39 change */ VARCHAR2
100 );
101 --
102 -- API name : ShowSQL
103 -- Type : Private
104 -- Function : Shows the text of the dynamically built SQL statement using
105 -- dbms_output. Needed for debugging.
106 -- Pre-reqs : none
107 -- Parameters :
108 -- p_sql_text in long required
109 -- Version : not tracked
110 -- Notes :
111 PROCEDURE ShowSql( p_sql_text IN long) ;
112 --
113 -- API name : ShowBindVars
114 -- Type : Private
115 -- Function : Shows all entries of the internal bind variable tables using
116 -- dbms_output. Needed for debugging.
117 -- Pre-reqs : none
118 -- Parameters : none
119 -- Version : not tracked
120 -- Notes :
121 PROCEDURE ShowBindVars;
122 END inv_sql_binding_pvt;