eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

SYS.DBMS_XQUERYINT dependencies on DUAL

Line 101: select SYS_XQ_PKSQL2XML(str, 1, 2) into xval from dual;

97: dbms_output.put_line('outflg = ' || to_char(outflg));
98: */
99: if xqtype = QMTXT_STRING then
100: /*DTYCHR; QMTXT_STRING;*/
101: select SYS_XQ_PKSQL2XML(str, 1, 2) into xval from dual;
102: elsif xqtype = QMTXT_DECIMAL then
103: /*DTYNUM; QMTXT_DECIMAL;*/
104: select SYS_XQ_PKSQL2XML(to_number(str), 2, 4) into xval from dual;
105: elsif xqtype = QMTXT_INTEGER then

Line 104: select SYS_XQ_PKSQL2XML(to_number(str), 2, 4) into xval from dual;

100: /*DTYCHR; QMTXT_STRING;*/
101: select SYS_XQ_PKSQL2XML(str, 1, 2) into xval from dual;
102: elsif xqtype = QMTXT_DECIMAL then
103: /*DTYNUM; QMTXT_DECIMAL;*/
104: select SYS_XQ_PKSQL2XML(to_number(str), 2, 4) into xval from dual;
105: elsif xqtype = QMTXT_INTEGER then
106: /*DTYNUM; QMTXT_INTEGER;*/
107: select SYS_XQ_PKSQL2XML(to_number(str), 2, 33) into xval from dual;
108: elsif xqtype = QMTXT_DATE then

Line 107: select SYS_XQ_PKSQL2XML(to_number(str), 2, 33) into xval from dual;

103: /*DTYNUM; QMTXT_DECIMAL;*/
104: select SYS_XQ_PKSQL2XML(to_number(str), 2, 4) into xval from dual;
105: elsif xqtype = QMTXT_INTEGER then
106: /*DTYNUM; QMTXT_INTEGER;*/
107: select SYS_XQ_PKSQL2XML(to_number(str), 2, 33) into xval from dual;
108: elsif xqtype = QMTXT_DATE then
109: /*DTYSTZ; QMTXT_DATE;*/
110: select SYS_XQ_PKSQL2XML(SYS_XMLCONV(str,3,10,0,0,181), 181, 10)
111: into xval

Line 112: from dual;

108: elsif xqtype = QMTXT_DATE then
109: /*DTYSTZ; QMTXT_DATE;*/
110: select SYS_XQ_PKSQL2XML(SYS_XMLCONV(str,3,10,0,0,181), 181, 10)
111: into xval
112: from dual;
113: elsif xqtype = QMTXT_TIME then
114: /*DTYSTZ; QMTXT_TIME;*/
115: select SYS_XQ_PKSQL2XML(SYS_XMLCONV(str,3,9,0,0,181), 181, 9)
116: into xval

Line 117: from dual;

113: elsif xqtype = QMTXT_TIME then
114: /*DTYSTZ; QMTXT_TIME;*/
115: select SYS_XQ_PKSQL2XML(SYS_XMLCONV(str,3,9,0,0,181), 181, 9)
116: into xval
117: from dual;
118: elsif xqtype = QMTXT_DATETIME then
119: /*DTYSTZ; QMTXT_DATETIME;*/
120: select SYS_XQ_PKSQL2XML(SYS_XMLCONV(str,3,8,0,0,181), 181, 8)
121: into xval

Line 122: from dual;

118: elsif xqtype = QMTXT_DATETIME then
119: /*DTYSTZ; QMTXT_DATETIME;*/
120: select SYS_XQ_PKSQL2XML(SYS_XMLCONV(str,3,8,0,0,181), 181, 8)
121: into xval
122: from dual;
123: elsif xqtype = QMTXT_FLOAT then
124: /*DTYIBFLOAT; QMTXT_FLOAT;*/
125: select SYS_XQ_PKSQL2XML(to_binary_float(str), 100, 5) into xval from dual;
126: elsif xqtype = QMTXT_DOUBLE then

Line 125: select SYS_XQ_PKSQL2XML(to_binary_float(str), 100, 5) into xval from dual;

121: into xval
122: from dual;
123: elsif xqtype = QMTXT_FLOAT then
124: /*DTYIBFLOAT; QMTXT_FLOAT;*/
125: select SYS_XQ_PKSQL2XML(to_binary_float(str), 100, 5) into xval from dual;
126: elsif xqtype = QMTXT_DOUBLE then
127: /*DTYIBDOUBLE; QMTXT_DOUBLE;*/
128: select SYS_XQ_PKSQL2XML(to_binary_double(str), 101, 6) into xval from dual;
129: elsif xqtype = QMTXT_XDT_YEARMONTHDURATION then

Line 128: select SYS_XQ_PKSQL2XML(to_binary_double(str), 101, 6) into xval from dual;

124: /*DTYIBFLOAT; QMTXT_FLOAT;*/
125: select SYS_XQ_PKSQL2XML(to_binary_float(str), 100, 5) into xval from dual;
126: elsif xqtype = QMTXT_DOUBLE then
127: /*DTYIBDOUBLE; QMTXT_DOUBLE;*/
128: select SYS_XQ_PKSQL2XML(to_binary_double(str), 101, 6) into xval from dual;
129: elsif xqtype = QMTXT_XDT_YEARMONTHDURATION then
130: /*DTYEIYM; QMTXT_XDT_YEARMONTHDURATION;*/
131: select SYS_XQ_PKSQL2XML(SYS_XMLCONV(str,3,52,0,0,189), 189, 52) into xval from dual;
132: elsif xqtype = QMTXT_XDT_DAYTIMEDURATION then

Line 131: select SYS_XQ_PKSQL2XML(SYS_XMLCONV(str,3,52,0,0,189), 189, 52) into xval from dual;

127: /*DTYIBDOUBLE; QMTXT_DOUBLE;*/
128: select SYS_XQ_PKSQL2XML(to_binary_double(str), 101, 6) into xval from dual;
129: elsif xqtype = QMTXT_XDT_YEARMONTHDURATION then
130: /*DTYEIYM; QMTXT_XDT_YEARMONTHDURATION;*/
131: select SYS_XQ_PKSQL2XML(SYS_XMLCONV(str,3,52,0,0,189), 189, 52) into xval from dual;
132: elsif xqtype = QMTXT_XDT_DAYTIMEDURATION then
133: /*DTYEIDS; QMTXT_XDT_DAYTIMEDURATION;*/
134: select SYS_XQ_PKSQL2XML(SYS_XMLCONV(str,3,51,0,0,190), 190, 51) into xval from dual;
135: elsif xqtype = QMTXT_BOOLEAN then

Line 134: select SYS_XQ_PKSQL2XML(SYS_XMLCONV(str,3,51,0,0,190), 190, 51) into xval from dual;

130: /*DTYEIYM; QMTXT_XDT_YEARMONTHDURATION;*/
131: select SYS_XQ_PKSQL2XML(SYS_XMLCONV(str,3,52,0,0,189), 189, 52) into xval from dual;
132: elsif xqtype = QMTXT_XDT_DAYTIMEDURATION then
133: /*DTYEIDS; QMTXT_XDT_DAYTIMEDURATION;*/
134: select SYS_XQ_PKSQL2XML(SYS_XMLCONV(str,3,51,0,0,190), 190, 51) into xval from dual;
135: elsif xqtype = QMTXT_BOOLEAN then
136: /*DTYBIN; QMTXT_BOOLEAN;*/
137: select SYS_XQ_PKSQL2XML(case SYS_XQ_ATOMCNVCHK(str,1,3) WHEN '0' THEN HEXTORAW('00') ELSE HEXTORAW('01') END, 23, 3) into xval from dual;
138: elsif xqtype = QMTXT_GDAY then

Line 137: select SYS_XQ_PKSQL2XML(case SYS_XQ_ATOMCNVCHK(str,1,3) WHEN '0' THEN HEXTORAW('00') ELSE HEXTORAW('01') END, 23, 3) into xval from dual;

133: /*DTYEIDS; QMTXT_XDT_DAYTIMEDURATION;*/
134: select SYS_XQ_PKSQL2XML(SYS_XMLCONV(str,3,51,0,0,190), 190, 51) into xval from dual;
135: elsif xqtype = QMTXT_BOOLEAN then
136: /*DTYBIN; QMTXT_BOOLEAN;*/
137: select SYS_XQ_PKSQL2XML(case SYS_XQ_ATOMCNVCHK(str,1,3) WHEN '0' THEN HEXTORAW('00') ELSE HEXTORAW('01') END, 23, 3) into xval from dual;
138: elsif xqtype = QMTXT_GDAY then
139: /*DTYSTZ; QMTXT_GDAY;*/
140: select SYS_XQ_PKSQL2XML(SYS_XMLCONV(str,3,11,0,0,181), 181, 11) into xval from dual;
141: elsif xqtype = QMTXT_GMONTH then

Line 140: select SYS_XQ_PKSQL2XML(SYS_XMLCONV(str,3,11,0,0,181), 181, 11) into xval from dual;

136: /*DTYBIN; QMTXT_BOOLEAN;*/
137: select SYS_XQ_PKSQL2XML(case SYS_XQ_ATOMCNVCHK(str,1,3) WHEN '0' THEN HEXTORAW('00') ELSE HEXTORAW('01') END, 23, 3) into xval from dual;
138: elsif xqtype = QMTXT_GDAY then
139: /*DTYSTZ; QMTXT_GDAY;*/
140: select SYS_XQ_PKSQL2XML(SYS_XMLCONV(str,3,11,0,0,181), 181, 11) into xval from dual;
141: elsif xqtype = QMTXT_GMONTH then
142: /*DTYSTZ; QMTXT_GMONTH;*/
143: select SYS_XQ_PKSQL2XML(SYS_XMLCONV(str,3,12,0,0,181), 181, 12) into xval from dual;
144: elsif xqtype = QMTXT_GYEAR then

Line 143: select SYS_XQ_PKSQL2XML(SYS_XMLCONV(str,3,12,0,0,181), 181, 12) into xval from dual;

139: /*DTYSTZ; QMTXT_GDAY;*/
140: select SYS_XQ_PKSQL2XML(SYS_XMLCONV(str,3,11,0,0,181), 181, 11) into xval from dual;
141: elsif xqtype = QMTXT_GMONTH then
142: /*DTYSTZ; QMTXT_GMONTH;*/
143: select SYS_XQ_PKSQL2XML(SYS_XMLCONV(str,3,12,0,0,181), 181, 12) into xval from dual;
144: elsif xqtype = QMTXT_GYEAR then
145: /*DTYSTZ; QMTXT_GYEAR;*/
146: select SYS_XQ_PKSQL2XML(SYS_XMLCONV(str,3,13,0,0,181), 181, 13) into xval from dual;
147: elsif xqtype = QMTXT_GYEARMONTH then

Line 146: select SYS_XQ_PKSQL2XML(SYS_XMLCONV(str,3,13,0,0,181), 181, 13) into xval from dual;

142: /*DTYSTZ; QMTXT_GMONTH;*/
143: select SYS_XQ_PKSQL2XML(SYS_XMLCONV(str,3,12,0,0,181), 181, 12) into xval from dual;
144: elsif xqtype = QMTXT_GYEAR then
145: /*DTYSTZ; QMTXT_GYEAR;*/
146: select SYS_XQ_PKSQL2XML(SYS_XMLCONV(str,3,13,0,0,181), 181, 13) into xval from dual;
147: elsif xqtype = QMTXT_GYEARMONTH then
148: /*DTYSTZ; QMTXT_GYEARMONTH;*/
149: select SYS_XQ_PKSQL2XML(SYS_XMLCONV(str,3,14,0,0,181), 181, 14) into xval from dual;
150: elsif xqtype = QMTXT_GMONTHDAY then

Line 149: select SYS_XQ_PKSQL2XML(SYS_XMLCONV(str,3,14,0,0,181), 181, 14) into xval from dual;

145: /*DTYSTZ; QMTXT_GYEAR;*/
146: select SYS_XQ_PKSQL2XML(SYS_XMLCONV(str,3,13,0,0,181), 181, 13) into xval from dual;
147: elsif xqtype = QMTXT_GYEARMONTH then
148: /*DTYSTZ; QMTXT_GYEARMONTH;*/
149: select SYS_XQ_PKSQL2XML(SYS_XMLCONV(str,3,14,0,0,181), 181, 14) into xval from dual;
150: elsif xqtype = QMTXT_GMONTHDAY then
151: /*DTYSTZ; QMTXT_GMONTHDAY;*/
152: select SYS_XQ_PKSQL2XML(SYS_XMLCONV(str,3,15,0,0,181), 181, 15) into xval from dual;
153: elsif xqtype = QMTXT_DURATION then

Line 152: select SYS_XQ_PKSQL2XML(SYS_XMLCONV(str,3,15,0,0,181), 181, 15) into xval from dual;

148: /*DTYSTZ; QMTXT_GYEARMONTH;*/
149: select SYS_XQ_PKSQL2XML(SYS_XMLCONV(str,3,14,0,0,181), 181, 14) into xval from dual;
150: elsif xqtype = QMTXT_GMONTHDAY then
151: /*DTYSTZ; QMTXT_GMONTHDAY;*/
152: select SYS_XQ_PKSQL2XML(SYS_XMLCONV(str,3,15,0,0,181), 181, 15) into xval from dual;
153: elsif xqtype = QMTXT_DURATION then
154: /*DTYCHR; QMTXT_DURATION;*/
155: select SYS_XQ_PKSQL2XML(str, 1,7) into xval from dual;
156: elsif xqtype = QMTXT_XDT_UNTYPEDATOMIC then

Line 155: select SYS_XQ_PKSQL2XML(str, 1,7) into xval from dual;

151: /*DTYSTZ; QMTXT_GMONTHDAY;*/
152: select SYS_XQ_PKSQL2XML(SYS_XMLCONV(str,3,15,0,0,181), 181, 15) into xval from dual;
153: elsif xqtype = QMTXT_DURATION then
154: /*DTYCHR; QMTXT_DURATION;*/
155: select SYS_XQ_PKSQL2XML(str, 1,7) into xval from dual;
156: elsif xqtype = QMTXT_XDT_UNTYPEDATOMIC then
157: /*DTYCHR; QMTXT_XDT_UNTYPEDATOMIC;*/
158: select SYS_XQ_PKSQL2XML(str, 1,50) into xval from dual;
159: elsif xqtype = QMTXT_BASE64BINARY then

Line 158: select SYS_XQ_PKSQL2XML(str, 1,50) into xval from dual;

154: /*DTYCHR; QMTXT_DURATION;*/
155: select SYS_XQ_PKSQL2XML(str, 1,7) into xval from dual;
156: elsif xqtype = QMTXT_XDT_UNTYPEDATOMIC then
157: /*DTYCHR; QMTXT_XDT_UNTYPEDATOMIC;*/
158: select SYS_XQ_PKSQL2XML(str, 1,50) into xval from dual;
159: elsif xqtype = QMTXT_BASE64BINARY then
160: /*DTYBIN; QMTXT_BASE64BINARY ;*/
161: select SYS_XQ_PKSQL2XML(SYS_XMLCONV(str,3,17,0,0,23), 23, 17) into xval from dual;
162: elsif xqtype = QMTXT_HEXBINARY then

Line 161: select SYS_XQ_PKSQL2XML(SYS_XMLCONV(str,3,17,0,0,23), 23, 17) into xval from dual;

157: /*DTYCHR; QMTXT_XDT_UNTYPEDATOMIC;*/
158: select SYS_XQ_PKSQL2XML(str, 1,50) into xval from dual;
159: elsif xqtype = QMTXT_BASE64BINARY then
160: /*DTYBIN; QMTXT_BASE64BINARY ;*/
161: select SYS_XQ_PKSQL2XML(SYS_XMLCONV(str,3,17,0,0,23), 23, 17) into xval from dual;
162: elsif xqtype = QMTXT_HEXBINARY then
163: /*DTYBIN; QMTXT_HEXBINARY ;*/
164: select SYS_XQ_PKSQL2XML(HEXTORAW(str), 23, 16) into xval from dual;
165: elsif xqtype = QMTXT_NONPOSITIVEINTEGER then

Line 164: select SYS_XQ_PKSQL2XML(HEXTORAW(str), 23, 16) into xval from dual;

160: /*DTYBIN; QMTXT_BASE64BINARY ;*/
161: select SYS_XQ_PKSQL2XML(SYS_XMLCONV(str,3,17,0,0,23), 23, 17) into xval from dual;
162: elsif xqtype = QMTXT_HEXBINARY then
163: /*DTYBIN; QMTXT_HEXBINARY ;*/
164: select SYS_XQ_PKSQL2XML(HEXTORAW(str), 23, 16) into xval from dual;
165: elsif xqtype = QMTXT_NONPOSITIVEINTEGER then
166: /*DTYNUM; QMTXT_NONPOSITIVEINTEGER ;*/
167: select SYS_XQ_PKSQL2XML(SYS_XQ_ATOMCNVCHK(to_number(str),2,34), 2, 34) into xval from dual;
168: elsif xqtype = QMTXT_NEGATIVEINTEGER then

Line 167: select SYS_XQ_PKSQL2XML(SYS_XQ_ATOMCNVCHK(to_number(str),2,34), 2, 34) into xval from dual;

163: /*DTYBIN; QMTXT_HEXBINARY ;*/
164: select SYS_XQ_PKSQL2XML(HEXTORAW(str), 23, 16) into xval from dual;
165: elsif xqtype = QMTXT_NONPOSITIVEINTEGER then
166: /*DTYNUM; QMTXT_NONPOSITIVEINTEGER ;*/
167: select SYS_XQ_PKSQL2XML(SYS_XQ_ATOMCNVCHK(to_number(str),2,34), 2, 34) into xval from dual;
168: elsif xqtype = QMTXT_NEGATIVEINTEGER then
169: /*DTYNUM; QMTXT_NEGATIVEINTEGER ;*/
170: select SYS_XQ_PKSQL2XML(SYS_XQ_ATOMCNVCHK(to_number(str),2,35), 2, 35) into xval from dual;
171: elsif xqtype = QMTXT_LONG then

Line 170: select SYS_XQ_PKSQL2XML(SYS_XQ_ATOMCNVCHK(to_number(str),2,35), 2, 35) into xval from dual;

166: /*DTYNUM; QMTXT_NONPOSITIVEINTEGER ;*/
167: select SYS_XQ_PKSQL2XML(SYS_XQ_ATOMCNVCHK(to_number(str),2,34), 2, 34) into xval from dual;
168: elsif xqtype = QMTXT_NEGATIVEINTEGER then
169: /*DTYNUM; QMTXT_NEGATIVEINTEGER ;*/
170: select SYS_XQ_PKSQL2XML(SYS_XQ_ATOMCNVCHK(to_number(str),2,35), 2, 35) into xval from dual;
171: elsif xqtype = QMTXT_LONG then
172: /*DTYNUM; QMTXT_LONG ;*/
173: select SYS_XQ_PKSQL2XML(SYS_XQ_ATOMCNVCHK(to_number(str),2,36), 2, 36) into xval from dual;
174: elsif xqtype = QMTXT_INT then

Line 173: select SYS_XQ_PKSQL2XML(SYS_XQ_ATOMCNVCHK(to_number(str),2,36), 2, 36) into xval from dual;

169: /*DTYNUM; QMTXT_NEGATIVEINTEGER ;*/
170: select SYS_XQ_PKSQL2XML(SYS_XQ_ATOMCNVCHK(to_number(str),2,35), 2, 35) into xval from dual;
171: elsif xqtype = QMTXT_LONG then
172: /*DTYNUM; QMTXT_LONG ;*/
173: select SYS_XQ_PKSQL2XML(SYS_XQ_ATOMCNVCHK(to_number(str),2,36), 2, 36) into xval from dual;
174: elsif xqtype = QMTXT_INT then
175: /*DTYNUM; QMTXT_POSITIVEINTEGER ;*/
176: select SYS_XQ_PKSQL2XML(SYS_XQ_ATOMCNVCHK(to_number(str),2,37), 2, 37) into xval from dual;
177: elsif xqtype = QMTXT_SHORT then

Line 176: select SYS_XQ_PKSQL2XML(SYS_XQ_ATOMCNVCHK(to_number(str),2,37), 2, 37) into xval from dual;

172: /*DTYNUM; QMTXT_LONG ;*/
173: select SYS_XQ_PKSQL2XML(SYS_XQ_ATOMCNVCHK(to_number(str),2,36), 2, 36) into xval from dual;
174: elsif xqtype = QMTXT_INT then
175: /*DTYNUM; QMTXT_POSITIVEINTEGER ;*/
176: select SYS_XQ_PKSQL2XML(SYS_XQ_ATOMCNVCHK(to_number(str),2,37), 2, 37) into xval from dual;
177: elsif xqtype = QMTXT_SHORT then
178: /*DTYNUM; QMTXT_SHORT ;*/
179: select SYS_XQ_PKSQL2XML(SYS_XQ_ATOMCNVCHK(to_number(str),2,38), 2, 38) into xval from dual;
180: elsif xqtype = QMTXT_BYTE then

Line 179: select SYS_XQ_PKSQL2XML(SYS_XQ_ATOMCNVCHK(to_number(str),2,38), 2, 38) into xval from dual;

175: /*DTYNUM; QMTXT_POSITIVEINTEGER ;*/
176: select SYS_XQ_PKSQL2XML(SYS_XQ_ATOMCNVCHK(to_number(str),2,37), 2, 37) into xval from dual;
177: elsif xqtype = QMTXT_SHORT then
178: /*DTYNUM; QMTXT_SHORT ;*/
179: select SYS_XQ_PKSQL2XML(SYS_XQ_ATOMCNVCHK(to_number(str),2,38), 2, 38) into xval from dual;
180: elsif xqtype = QMTXT_BYTE then
181: /*DTYNUM; QMTXT_BYTE ;*/
182: select SYS_XQ_PKSQL2XML(SYS_XQ_ATOMCNVCHK(to_number(str),2,39), 2, 39) into xval from dual;
183: elsif xqtype = QMTXT_NONNEGATIVEINTEGER then

Line 182: select SYS_XQ_PKSQL2XML(SYS_XQ_ATOMCNVCHK(to_number(str),2,39), 2, 39) into xval from dual;

178: /*DTYNUM; QMTXT_SHORT ;*/
179: select SYS_XQ_PKSQL2XML(SYS_XQ_ATOMCNVCHK(to_number(str),2,38), 2, 38) into xval from dual;
180: elsif xqtype = QMTXT_BYTE then
181: /*DTYNUM; QMTXT_BYTE ;*/
182: select SYS_XQ_PKSQL2XML(SYS_XQ_ATOMCNVCHK(to_number(str),2,39), 2, 39) into xval from dual;
183: elsif xqtype = QMTXT_NONNEGATIVEINTEGER then
184: /*DTYNUM; QMTXT_NONNEGATIVEINTEGER ;*/
185: select SYS_XQ_PKSQL2XML(SYS_XQ_ATOMCNVCHK(to_number(str),2,40), 2, 40) into xval from dual;
186: elsif xqtype = QMTXT_UNSIGNEDLONG then

Line 185: select SYS_XQ_PKSQL2XML(SYS_XQ_ATOMCNVCHK(to_number(str),2,40), 2, 40) into xval from dual;

181: /*DTYNUM; QMTXT_BYTE ;*/
182: select SYS_XQ_PKSQL2XML(SYS_XQ_ATOMCNVCHK(to_number(str),2,39), 2, 39) into xval from dual;
183: elsif xqtype = QMTXT_NONNEGATIVEINTEGER then
184: /*DTYNUM; QMTXT_NONNEGATIVEINTEGER ;*/
185: select SYS_XQ_PKSQL2XML(SYS_XQ_ATOMCNVCHK(to_number(str),2,40), 2, 40) into xval from dual;
186: elsif xqtype = QMTXT_UNSIGNEDLONG then
187: /*DTYNUM; UNSIGNEDLONG ;*/
188: select SYS_XQ_PKSQL2XML(SYS_XQ_ATOMCNVCHK(to_number(str),2,41), 2, 41) into xval from dual;
189: elsif xqtype = QMTXT_UNSIGNEDINT then

Line 188: select SYS_XQ_PKSQL2XML(SYS_XQ_ATOMCNVCHK(to_number(str),2,41), 2, 41) into xval from dual;

184: /*DTYNUM; QMTXT_NONNEGATIVEINTEGER ;*/
185: select SYS_XQ_PKSQL2XML(SYS_XQ_ATOMCNVCHK(to_number(str),2,40), 2, 40) into xval from dual;
186: elsif xqtype = QMTXT_UNSIGNEDLONG then
187: /*DTYNUM; UNSIGNEDLONG ;*/
188: select SYS_XQ_PKSQL2XML(SYS_XQ_ATOMCNVCHK(to_number(str),2,41), 2, 41) into xval from dual;
189: elsif xqtype = QMTXT_UNSIGNEDINT then
190: /*DTYNUM; UNSIGNEDINT ;*/
191: select SYS_XQ_PKSQL2XML(SYS_XQ_ATOMCNVCHK(to_number(str),2,42), 2, 42) into xval from dual;
192: elsif xqtype = QMTXT_UNSIGNEDSHORT then

Line 191: select SYS_XQ_PKSQL2XML(SYS_XQ_ATOMCNVCHK(to_number(str),2,42), 2, 42) into xval from dual;

187: /*DTYNUM; UNSIGNEDLONG ;*/
188: select SYS_XQ_PKSQL2XML(SYS_XQ_ATOMCNVCHK(to_number(str),2,41), 2, 41) into xval from dual;
189: elsif xqtype = QMTXT_UNSIGNEDINT then
190: /*DTYNUM; UNSIGNEDINT ;*/
191: select SYS_XQ_PKSQL2XML(SYS_XQ_ATOMCNVCHK(to_number(str),2,42), 2, 42) into xval from dual;
192: elsif xqtype = QMTXT_UNSIGNEDSHORT then
193: /*DTYNUM; UNSIGNEDSHORT ;*/
194: select SYS_XQ_PKSQL2XML(SYS_XQ_ATOMCNVCHK(to_number(str),2,43), 2, 43) into xval from dual;
195: elsif xqtype = QMTXT_UNSIGNEDBYTE then

Line 194: select SYS_XQ_PKSQL2XML(SYS_XQ_ATOMCNVCHK(to_number(str),2,43), 2, 43) into xval from dual;

190: /*DTYNUM; UNSIGNEDINT ;*/
191: select SYS_XQ_PKSQL2XML(SYS_XQ_ATOMCNVCHK(to_number(str),2,42), 2, 42) into xval from dual;
192: elsif xqtype = QMTXT_UNSIGNEDSHORT then
193: /*DTYNUM; UNSIGNEDSHORT ;*/
194: select SYS_XQ_PKSQL2XML(SYS_XQ_ATOMCNVCHK(to_number(str),2,43), 2, 43) into xval from dual;
195: elsif xqtype = QMTXT_UNSIGNEDBYTE then
196: /*DTYNUM; UNSIGNEDBYTE ;*/
197: select SYS_XQ_PKSQL2XML(SYS_XQ_ATOMCNVCHK(to_number(str),2,44), 2, 44) into xval from dual;
198: elsif xqtype = QMTXT_POSITIVEINTEGER then

Line 197: select SYS_XQ_PKSQL2XML(SYS_XQ_ATOMCNVCHK(to_number(str),2,44), 2, 44) into xval from dual;

193: /*DTYNUM; UNSIGNEDSHORT ;*/
194: select SYS_XQ_PKSQL2XML(SYS_XQ_ATOMCNVCHK(to_number(str),2,43), 2, 43) into xval from dual;
195: elsif xqtype = QMTXT_UNSIGNEDBYTE then
196: /*DTYNUM; UNSIGNEDBYTE ;*/
197: select SYS_XQ_PKSQL2XML(SYS_XQ_ATOMCNVCHK(to_number(str),2,44), 2, 44) into xval from dual;
198: elsif xqtype = QMTXT_POSITIVEINTEGER then
199: /*DTYNUM; QMTXT_POSITIVEINTEGER ;*/
200: select SYS_XQ_PKSQL2XML(SYS_XQ_ATOMCNVCHK(to_number(str),2,45), 2, 45) into xval from dual;
201: else

Line 200: select SYS_XQ_PKSQL2XML(SYS_XQ_ATOMCNVCHK(to_number(str),2,45), 2, 45) into xval from dual;

196: /*DTYNUM; UNSIGNEDBYTE ;*/
197: select SYS_XQ_PKSQL2XML(SYS_XQ_ATOMCNVCHK(to_number(str),2,44), 2, 44) into xval from dual;
198: elsif xqtype = QMTXT_POSITIVEINTEGER then
199: /*DTYNUM; QMTXT_POSITIVEINTEGER ;*/
200: select SYS_XQ_PKSQL2XML(SYS_XQ_ATOMCNVCHK(to_number(str),2,45), 2, 45) into xval from dual;
201: else
202: /*DTYCHR; QMTXT_STRING;*/
203: select SYS_XQ_PKSQL2XML(str, 1, 2) into xval from dual;
204: end if;

Line 203: select SYS_XQ_PKSQL2XML(str, 1, 2) into xval from dual;

199: /*DTYNUM; QMTXT_POSITIVEINTEGER ;*/
200: select SYS_XQ_PKSQL2XML(SYS_XQ_ATOMCNVCHK(to_number(str),2,45), 2, 45) into xval from dual;
201: else
202: /*DTYCHR; QMTXT_STRING;*/
203: select SYS_XQ_PKSQL2XML(str, 1, 2) into xval from dual;
204: end if;
205: else
206: if bitand(outflg, QMXQRS_JAVA_NO_DOCWRAP) = QMXQRS_JAVA_NO_DOCWRAP then
207: noDocWrap := 1;

Line 225: from dual;

221: xval :=
222: xmltype.createxml(''||clb ||'',null,1,1).extract('/A/node()');
223: /*
224: select extract(xmltype.createxml(''||clb ||'',null,1,1),'/A/node()') into xval
225: from dual;
226: */
227: else
228: /* only document node or single element node goes to here */
229: xval := xmltype.createxml(clb,null,1,1);

Line 239: select sys_xqcon2seq(xval) into xval from dual;

235: if (noDocWrap = 1) then
236: /* turn on NO_DOCWRAP flag in the image for node without document node
237: * wrapper.
238: */
239: select sys_xqcon2seq(xval) into xval from dual;
240: end if;
241:
242: select sys_xqconcat(ret, xval) into ret from dual;
243:

Line 242: select sys_xqconcat(ret, xval) into ret from dual;

238: */
239: select sys_xqcon2seq(xval) into xval from dual;
240: end if;
241:
242: select sys_xqconcat(ret, xval) into ret from dual;
243:
244: end loop;
245:
246: /* we cache the xquery plan in qmxqrs.c level, so we don't close the