Advertisement

12.27.2007 at 05:45PM PST, ID: 23046329
[x]
Attachment Details
[x]
The Solution Rating System

With so many solutions, how can you tell which solutions are most likely to help you and which ones are not? To provide you with a tool to use, we rate our solutions based on various elements that most accurately determine if a solution is a quality solution. To explain what factors affect the solution rating, here are the elements we take into consideration when formulating our solution rating.

  • The Grade of the Solution
  • The Zone Rank of the Expert Providing the Solution
  • The Number of Author and Expert Comments
  • The Number of Experts Contributing
  • The Feedback of the Community

Your Input Matters
Because of the way the system is set up, the most important variable in this equation is you. As a member of Experts Exchange, you are able to cast your vote on the quality of the solutions in regard to how complete, accurate, helpful and easy to understand each solution is. When you provide your feedback, each rating is adjusted accordingly. So, if you see a solution that has a poor rating that you think is a good solution, let us know by rating it. As you do, the rating will be adjusted and will become more accurate for other members of our site.

If you have any suggestions that you would like to make for our rating system, please ask a question in the Suggestions Zone of Community Support.

Thank you!
7.0

Exporting Oracle Stored Procedures

Asked by sstukwila in Oracle Database, Oracle 8.x, PL / SQL

Tags: , , ,

Hi, Exporting stored procedures fail with the following error message.
      . exporting stored procedures
      EXP-00008: ORACLE error 1406 encountered
      ORA-01406: fetched column value was truncated
      EXP-00000: Export terminated unsuccessfully
- When I look into the stored procedures in SQL Navigator, I see what I have added in the Code Snippet.

Any thoughts on why I am seeing the stored proc this way in SQL Navigator? I am using Oracle 8.1.7.4.1
and any thoughts on the export issue?

Thanks a lot.Start Free Trial 
1:
2:
3:
4:
5:
6:
7:
8:
9:
10:
11:
12:
13:
14:
15:
16:
17:
18:
19:
20:
21:
22:
23:
24:
25:
26:
27:
28:
29:
30:
31:
32:
33:
34:
35:
36:
37:
38:
39:
40:
41:
42:
43:
44:
45:
46:
47:
48:
49:
50:
51:
52:
53:
54:
55:
56:
57:
58:
59:
60:
61:
62:
63:
64:
65:
66:
67:
68:
69:
70:
71:
72:
73:
74:
75:
76:
77:
78:
79:
80:
81:
82:
83:
84:
85:
86:
87:
88:
89:
90:
91:
92:
93:
94:
95:
96:
97:
98:
99:
100:
101:
102:
103:
104:
105:
106:
107:
108:
109:
110:
111:
112:
113:
114:
115:
116:
117:
118:
119:
120:
121:
122:
123:
124:
125:
126:
127:
128:
129:
130:
131:
132:
133:
134:
135:
136:
137:
138:
139:
140:
141:
142:
143:
144:
145:
146:
147:
148:
149:
150:
151:
152:
153:
154:
155:
156:
157:
158:
159:
160:
161:
162:
163:
164:
165:
166:
167:
168:
169:
170:
171:
172:
173:
174:
175:
176:
177:
178:
179:
180:
181:
182:
183:
184:
185:
186:
187:
188:
189:
190:
191:
192:
193:
194:
195:
196:
197:
198:
199:
200:
201:
202:
203:
204:
205:
206:
207:
208:
209:
210:
211:
212:
213:
214:
215:
216:
217:
218:
219:
220:
221:
222:
223:
224:
225:
226:
227:
228:
229:
230:
231:
232:
233:
234:
235:
236:
237:
238:
239:
240:
241:
242:
243:
244:
245:
246:
247:
248:
249:
250:
251:
252:
253:
254:
255:
256:
257:
258:
259:
260:
261:
262:
263:
264:
265:
266:
267:
268:
269:
270:
271:
272:
273:
274:
275:
276:
277:
278:
279:
280:
281:
282:
283:
284:
285:
286:
287:
288:
289:
290:
291:
292:
293:
294:
295:
296:
297:
298:
299:
300:
301:
302:
303:
304:
305:
306:
307:
308:
309:
310:
311:
312:
313:
314:
315:
316:
317:
318:
319:
320:
321:
322:
323:
324:
325:
326:
327:
328:
329:
330:

PROCEDURE               CLONE_ROUTE wrapped
0
abcd
abcd
abcd
abcd
abcd
abcd
abcd
abcd
abcd
abcd
abcd
abcd
abcd
abcd
abcd
abcd
7
8003000
1
4
0
3f
b CLONE_ROUTE:
a P_OROUTEID:
8 VARCHAR2:
a P_NROUTEID:
c P_RETURNCODE:
3 OUT:
6 NUMBER:
a L_OROUTEID:
2 20:
a L_NROUTEID:
c L_RETURNCODE:
1 0:
6 CURSOR:
a ROUTE_CURS:
5 RTYPE:
5 ROUTE:
7 ROUTEID:
1 =:
b L_ROUTE_REC:
7 ROWTYPE:
4 OPEN:
8 NOTFOUND:
5 CLOSE:
5 FOUND:
b DESCRIPTION:
c ACCESSNUMBER:
a ACCESSTONE:
b ACCESSDELAY:
b BUFFERLIMIT:
8 WAITTONE:
8 WAITTIME:
9 SENDAUTH1:
9 SENDAUTH2:
9 CARDDEST1:
9 CARDDEST2:
d TONEAFTERCARD:
d TIMEAFTERCARD:
a SPLASHBACK:
e ALTSPLASHROUTE:
c ALTBUSYROUTE:
b CARDDATAFMT:
8 FIELDSEP:
c FIELDSEPTONE:
d FIELDSEPDELAY:
9 ENDDATAMK:
d ENDDATAMKTONE:
e ENDDATAMKDELAY:
d AUTHCODE1TYPE:
d AUTHCODE2TYPE:
9 AUTH1TONE:
a AUTH1DELAY:
9 AUTH2TONE:
a AUTH2DELAY:
b AUTHCODE1ID:
b AUTHCODE2ID:
a SIMPLEEDIT:
6 ISCARD:
6 COMMIT:
1 -:
4 2000:
4 1000:
6 OTHERS:
7 SQLCODE:
0
 
0
0
128
2
0 1d 9a 8f a0 b0 3d 8f
a0 b0 3d 96 :2 a0 b0 54 b4
55 6a a3 a0 51 a5 1c a0
81 b0 a3 a0 51 a5 1c a0
81 b0 a3 a0 1c 51 81 b0
a0 f4 8f a0 b0 3d b4 bf
c8 ac a0 b2 ee :2 a0 7e b4
2e ac d0 e5 e9 bd b7 11
a4 b1 a3 :2 a0 f 1c 81 b0
:3 a0 a5 dd e9 :2 a0 e9 d3 :2 a0
f :2 a0 e9 c1 :3 a0 a5 dd e9
:2 a0 e9 d3 :2 a0 f :26 a0 6b :2 a0
6b :2 a0 6b :2 a0 6b :2 a0 6b :2 a0
6b :2 a0 6b :2 a0 6b :2 a0 6b :2 a0
6b :2 a0 6b :2 a0 6b :2 a0 6b :2 a0
6b :2 a0 6b :2 a0 6b :2 a0 6b :2 a0
6b :2 a0 6b :2 a0 6b :2 a0 6b :2 a0
6b :2 a0 6b :2 a0 6b :2 a0 6b :2 a0
6b :2 a0 6b :2 a0 6b :2 a0 6b :2 a0
6b :2 a0 6b :2 a0 6b :2 a0 6b 5
d7 b2 5 e9 a0 57 a0 b4
e9 :2 a0 d b7 a0 7e 51 b4
2e d b7 :2 19 3c b7 a0 7e
51 b4 2e d b7 :2 19 3c :2 a0
e9 c1 b7 a0 53 :2 a0 d b7
a6 9 a4 a0 b1 11 68 4f
17 b5
128
2
0 3 4 1c 18 17 24 31
2d 16 39 46 3e 42 2c 4c
2b 51 55 75 5d 61 64 65
6d 71 5c 95 80 59 84 85
8d 91 7f b0 a0 a4 7c ac
9f b7 bb d2 ce 9e da cd
ca df e3 e4 e8 e9 f0 f4
f8 fb fc 101 102 106 10c 111
9c 116 121 29 141 129 12d 131
135 13d 128 148 14c 150 127 159
154 15d 161 165 16a 16e 172 176
17a 17e 182 125 187 18b 18f 193
199 194 19d 1a1 1a5 1aa 1ae 1b2
1b6 1ba 1be 1c2 1c6 1ca 1ce 1d2
1d6 1da 1de 1e2 1e6 1ea 1ee 1f2
1f6 1fa 1fe 202 206 20a 20e 212
216 21a 21e 222 226 22a 22e 232
236 23a 23e 242 246 24a 24e 252
255 259 25d 260 264 268 26b 26f
273 276 27a 27e 281 285 289 28c
290 294 297 29b 29f 2a2 2a6 2aa
2ad 2b1 2b5 2b8 2bc 2c0 2c3 2c7
2cb 2ce 2d2 2d6 2d9 2dd 2e1 2e4
2e8 2ec 2ef 2f3 2f7 2fa 2fe 302
305 309 30d 310 314 318 31b 31f
323 326 32a 32e 331 335 339 33c
340 344 347 34b 34f 352 356 35a
35d 361 365 368 36c 370 373 377
37b 37e 382 386 389 38d 391 394
398 39c 39f 3a3 3a7 3aa 3ae 3b2
3b5 3b9 3c1 3c2 3c6 3cb 3cf 3d4
3d8 3d9 3de 3e2 3e6 14 3ea 3ee
3f1 3f4 3f5 3fa 3fe 400 404 408
40b 40d 411 414 417 418 41d 421
423 427 42b 42e 432 436 43b 43d
43f 1 443 447 44b 44f 451 452
457 45b 45f 461 46c 470 472 479
128
2
0 1 19 27 36 :2 27 9 1c
:2 9 10 1f 23 :2 10 25 :3 1 e
17 16 e 1e e :2 1 e 17
16 e 1e e :2 1 :2 11 1c 11
:2 1 9 14 1a :2 14 13 :2 1 a
7 1 7 8 12 :3 10 :a 1 e
19 :3 e 1 3 8 13 :2 8 3
9 19 :2 3 6 11 6 5 b
:3 5 a 16 :2 a 5 b 1b :3 5
10 5 8 15 :21 7 11 7 :2 13
7 :2 13 7 :2 13 7 :2 13 7 :2 13
7 :2 13 7 :2 13 7 :2 13 7 :2 13
7 :2 13 7 :2 13 7 :2 13 7 :2 13
7 :2 13 7 :2 13 7 :2 13 7 :2 13
7 :2 13 7 :2 13 7 :2 13 7 :2 13
7 :2 13 7 :2 13 7 :2 13 7 :2 13
7 :2 13 7 :2 13 7 :2 13 7 :2 13
7 :2 13 7 :2 13 7 :2 13 7 :2 13
d :4 4 :5 8 3 13 3 16 5
16 17 :2 16 5 :4 2 1a 4 15
16 :2 15 4 :5 3 9 :2 3 1 :2 8
7 17 7 f :3 3 5 :6 1
128
2
0 :6 1 :4 3 :5 5 :3 1 :8 9 :8 b :6 d
:9 11 13 :3 15 :5 17 15 :3 13 :5 11 :7 19
:6 1d :4 1f :3 23 :4 25 :6 27 :4 29 :3 2f :2 33
35 37 39 3b 3d 3f 41 43
45 47 49 4b 4d 4f 51 53
55 57 59 5b 5d 5f 61 63
65 67 69 6b 6d 6f 71 73
75 77 :3 79 :3 7b :3 7d :3 7f :3 81 :3 83
:3 85 :3 87 :3 89 :3 8b :3 8d :3 8f :3 91 :3 93
:3 95 :3 97 :3 99 :3 9b :3 9d :3 9f :3 a1 :3 a3
:3 a5 :3 a7 :3 a9 :3 ab :3 ad :3 af :3 b1 :3 b3
:3 b5 :3 b7 :3 b9 77 :4 31 :5 bb :3 bd 2f
:6 c1 :2 bf :2 2f 23 :6 c7 :2 c5 :2 23 :4 cb
1b :2 cf :3 d1 :3 cf cd d3 :6 1
47b
2
:4 0 1 :a 0 124 1 :3 0 70 106
5 :2 3 :3 0 2 :7 0 5 4 :4 0
41 9 7 3 :3 0 4 :7 0 9
8 :3 0 6 :3 0 7 :3 0 5 :5 0
e d :3 0 10 :2 0 124 2 11
:2 0 9 :2 0 f 3 :3 0 9 :2 0
d 14 16 :6 0 2 :3 0 1a 17
18 122 8 :6 0 c :2 0 13 3
:3 0 11 1c 1e :6 0 4 :3 0 22
1f 20 122 a :6 0 1d 41 17
15 7 :3 0 24 :7 0 28 25 26
122 b :6 0 d :3 0 e :a 0 2
:3 0 2a 31 0 19 3 :3 0 f
:7 0 2d 2c :3 0 2f :4 0 10 :3 0
1b 34 3a 0 3b :3 0 11 :3 0
f :3 0 12 :2 0 1f 38 39 :5 0
32 35 0 3c :6 0 3d :2 0 40
2a 31 41 0 122 43 40 42
:6 0 3f :5 0 59 0 24 22 e
:3 0 14 :3 0 45 46 :2 0 47 :7 0
4a 48 0 122 13 :6 0 15 :3 0
e :3 0 a :4 0 4f :2 0 117 4c
4e :2 0 e :3 0 13 :4 0 54 :2 0
117 51 52 :2 0 e :3 0 16 :3 0
55 56 :2 0 17 :3 0 e :4 0 5b
:2 0 108 15 :3 0 e :3 0 8 :3 0
26 0 60 :2 0 108 5d 5f :2 0
e :3 0 13 :4 0 65 :2 0 108 62
63 :2 0 e :3 0 18 :3 0 66 67
:2 0 10 :3 0 11 :3 0 19 :3 0 1a
:3 0 1b :3 0 1c :3 0 1d :3 0 1e
:3 0 1f :3 0 20 :3 0 21 :3 0 22
:3 0 23 :3 0 24 :3 0 25 :3 0 26
:3 0 27 :3 0 28 :3 0 29 :3 0 2a
:3 0 2b :3 0 2c :3 0 2d :3 0 2e
:3 0 2f :3 0 30 :3 0 31 :3 0 32
:3 0 33 :3 0 34 :3 0 35 :3 0 36
:3 0 37 :3 0 38 :3 0 39 :3 0 a
:3 0 13 :3 0 19 :3 0 8d 8e 0
13 :3 0 1a :3 0 90 91 0 13
:3 0 1b :3 0 93 94 0 13 :3 0
1c :3 0 96 97 0 13 :3 0 1d
:3 0 99 9a 0 13 :3 0 1e :3 0
9c 9d 0 13 :3 0 1f :3 0 9f
a0 0 13 :3 0 20 :3 0 a2 a3
0 13 :3 0 21 :3 0 a5 a6 0
13 :3 0 22 :3 0 a8 a9 0 13
:3 0 23 :3 0 ab ac 0 13 :3 0
24 :3 0 ae af 0 13 :3 0 25
:3 0 b1 b2 0 13 :3 0 26 :3 0
b4 b5 0 13 :3 0 27 :3 0 b7
b8 0 13 :3 0 28 :3 0 ba bb
0 13 :3 0 29 :3 0 bd be 0
13 :3 0 2a :3 0 c0 c1 0 13
:3 0 2b :3 0 c3 c4 0 13 :3 0
2c :3 0 c6 c7 0 13 :3 0 2d
:3 0 c9 ca 0 13 :3 0 2e :3 0
cc cd 0 13 :3 0 2f :3 0 cf
d0 0 13 :3 0 30 :3 0 d2 d3
0 13 :3 0 31 :3 0 d5 d6 0
13 :3 0 32 :3 0 d8 d9 0 13
:3 0 33 :3 0 db dc 0 13 :3 0
34 :3 0 de df 0 13 :3 0 35
:3 0 e1 e2 0 13 :3 0 36 :3 0
e4 e5 0 13 :3 0 37 :3 0 e7
e8 0 13 :3 0 38 :3 0 ea eb
0 13 :3 0 39 :3 0 ed ee 0
28 :3 0 69 f2 f3 f4 :4 0 4b
6e :4 0 f1 :2 0 fd 3a :3 0 f7
f8 :2 0 f9 3a :5 0 f6 :2 0 fd
5 :3 0 b :3 0 fa fb 0 fd
5 :3 0 3b :2 0 3c :2 0 74 ff
101 :3 0 fe 102 0 104 76 105
0 104 0 107 68 fd 0 107
78 0 108 7b 111 5 :3 0 3b
:2 0 3d :2 0 80 10a 10c :3 0 109
10d 0 10f 82 110 0 10f 0
112 57 108 0 112 84 0 117
17 :3 0 e :4 0 116 :2 0 117 114
0 87 123 3e :3 0 b :3 0 3f
:3 0 11a 11b 0 11d 8c 11f 8e
11e 11d :2 0 120 90 :2 0 123 1
:3 0 92 123 122 117 120 :6 0 124
0 2 11 123 126 :2 0 1 124
127 :6 0
98
2
:3 0 1 3 1 7 1 b 3
6 a f 1 15 1 13 1
1d 1 1b 1 23 1 2b 1
2e 1 33 1 3e 2 36 37
1 44 1 4d 1 5e 22 8c
8f 92 95 98 9b 9e a1 a4
a7 aa ad b0 b3 b6 b9 bc
bf c2 c5 c8 cb ce d1 d4
d7 da dd e0 e3 e6 e9 ec
ef 22 6a 6b 6c 6d 6e 6f
70 71 72 73 74 75 76 77
78 79 7a 7b 7c 7d 7e 7f
80 81 82 83 84 85 86 87
88 89 8a 8b 1 f0 3 f4
f9 fc 1 100 1 103 2 106
105 4 5a 61 64 107 1 10b
1 10e 2 111 110 4 50 53
112 115 1 11c 1 119 1 11f
5 19 21 27 3f 49
1
4
0
126
0
1
14
2
a
0 1 0 0 0 0 0 0
0 0 0 0 0 0 0 0
0 0 0 0
2 0 1
1b 1 0
2a 1 2
13 1 0
7 1 0
2b 2 0
b 1 0
3 1 0
44 1 0
23 1 0
0
[+][-]12.27.2007 at 06:10PM PST, ID: 20539135

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]12.28.2007 at 03:17AM PST, ID: 20540982

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]12.28.2007 at 06:34PM PST, ID: 20546558

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]12.28.2007 at 10:01PM PST, ID: 20546944

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]12.31.2007 at 05:46PM PST, ID: 20558340

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]01.02.2008 at 08:16AM PST, ID: 20565379

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]01.02.2008 at 11:10AM PST, ID: 20566806

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]01.02.2008 at 11:59AM PST, ID: 20567286

View this solution now by starting your 7-day free trial. Setting up your free trial is quick, easy, and secure. We will return you to this solution, unlocked, when you're done.

 

About this solution

Zones: Oracle Database, Oracle 8.x, PL / SQL
Tags: Oracle, Oracle 8.1.7.4, 8.1.7.4.1, Back-up Export
Sign Up Now!
Solution Provided By: sjwales
Participating Experts: 2
Solution Grade: A
 
 
[+][-]01.03.2008 at 02:36PM PST, ID: 20577787

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]01.04.2008 at 08:46AM PST, ID: 20583803

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]01.05.2008 at 11:47AM PST, ID: 20590422

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]01.06.2008 at 03:11PM PST, ID: 20596078

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]01.09.2008 at 02:40PM PST, ID: 20623264

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]01.09.2008 at 03:54PM PST, ID: 20623737

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]01.10.2008 at 09:23AM PST, ID: 20629002

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
 
Loading Advertisement...
20080716-EE-VQP-32 / EE_QW_2_20070628