· 9 years ago · Jan 08, 2017, 01:36 AM
1
2SQL*Plus: Release 11.2.0.4.0 Production on Sun Jan 8 02:35:32 2017
3
4Copyright (c) 1982, 2013, Oracle. All rights reserved.
5
6
7Connected to:
8Oracle Database 11g Express Edition Release 11.2.0.2.0 - 64bit Production
9
10
11Type dropped.
12
13
14Type dropped.
15
16
17Type dropped.
18
19
20Type dropped.
21
22
23Type dropped.
24
25
26Type dropped.
27
28
29Type dropped.
30
31
32Type dropped.
33
34
35Type dropped.
36
37
38Type dropped.
39
40
41Type dropped.
42
43
44Type dropped.
45
46
47Type dropped.
48
49
50Type dropped.
51
52
53Type dropped.
54
55
56Type dropped.
57
58
59Type dropped.
60
61
62Type dropped.
63
64
65Type dropped.
66
67
68Type dropped.
69
70
71Sequence dropped.
72
73
74Trigger dropped.
75
76
77Sequence dropped.
78
79
80Trigger dropped.
81
82
83Sequence dropped.
84
85
86Trigger dropped.
87
88
89Sequence dropped.
90
91
92Trigger dropped.
93
94
95Sequence dropped.
96
97
98Trigger dropped.
99
100
101Sequence dropped.
102
103
104Trigger dropped.
105
106
107Sequence dropped.
108
109
110Trigger dropped.
111
112
113Sequence dropped.
114
115DROP TRIGGER PatientPkeySeq
116*
117ERROR at line 1:
118ORA-04080: trigger 'PATIENTPKEYSEQ' does not exist
119
120
121
122Sequence dropped.
123
124DROP TRIGGER MaladiePkeySeq
125*
126ERROR at line 1:
127ORA-04080: trigger 'MALADIEPKEYSEQ' does not exist
128
129
130
131Sequence dropped.
132
133
134Trigger dropped.
135
136
137Sequence dropped.
138
139
140Trigger dropped.
141
142
143Sequence dropped.
144
145
146Trigger dropped.
147
148
149Sequence dropped.
150
151
152Trigger dropped.
153
154
155Sequence dropped.
156
157
158Trigger dropped.
159
160
161Sequence dropped.
162
163
164Trigger dropped.
165
166
167Sequence dropped.
168
169DROP TRIGGER MaladiePatientPkeySeq
170*
171ERROR at line 1:
172ORA-04080: trigger 'MALADIEPATIENTPKEYSEQ' does not exist
173
174
175
176Sequence dropped.
177
178DROP TRIGGER MaladieTraitementPkeySeq
179*
180ERROR at line 1:
181ORA-04080: trigger 'MALADIETRAITEMENTPKEYSEQ' does not exist
182
183
184
185Sequence dropped.
186
187
188Trigger dropped.
189
190
191Sequence dropped.
192
193
194Trigger dropped.
195
196
197Table dropped.
198
199
200Table dropped.
201
202
203Table dropped.
204
205
206Table dropped.
207
208
209Table dropped.
210
211
212Table dropped.
213
214
215Table dropped.
216
217DROP TABLE Patient CASCADE CONSTRAINTS
218 *
219ERROR at line 1:
220ORA-00942: table or view does not exist
221
222
223DROP TABLE Maladie CASCADE CONSTRAINTS
224 *
225ERROR at line 1:
226ORA-00942: table or view does not exist
227
228
229
230Table dropped.
231
232
233Table dropped.
234
235
236Table dropped.
237
238
239Table dropped.
240
241
242Table dropped.
243
244
245Table dropped.
246
247DROP TABLE MaladiePatient CASCADE CONSTRAINTS
248 *
249ERROR at line 1:
250ORA-00942: table or view does not exist
251
252
253DROP TABLE MaladieTraitement CASCADE CONSTRAINTS
254 *
255ERROR at line 1:
256ORA-00942: table or view does not exist
257
258
259
260Table dropped.
261
262
263Table dropped.
264
265
266Type created.
267
268No errors.
269
270Type created.
271
272No errors.
273
274Type created.
275
276No errors.
277
278Type created.
279
280No errors.
281
282Type created.
283
284No errors.
285
286Type created.
287
288No errors.
289
290Type created.
291
292No errors.
293
294Type created.
295
296No errors.
297
298Type created.
299
300No errors.
301
302Type created.
303
304No errors.
305
306Type created.
307
308No errors.
309
310Warning: Type created with compilation errors.
311
312Errors for TYPE MALADIETYPE:
3138/41 PLS-00103: Encountered the symbol "TABLE" when expecting one of
314 the following:
315 <an identifier> <a double-quoted delimited-identifier> self
316 long double ref char time timestamp interval date binary
317 national character nchar
318
319
320Warning: Type created with compilation errors.
321
322Errors for TYPE MALADIELIST:
3230/0 PL/SQL: Compilation unit analysis terminated
3241/30 PLS-00905: object SYSTEM.MALADIETYPE is invalid
325
326Warning: Type created with compilation errors.
327
328Errors for TYPE PATIENTTYPE:
3290/0 PL/SQL: Compilation unit analysis terminated
3306/64 PLS-00201: identifier 'TRAITEMENT' must be declared
331
332Type created.
333
334No errors.
335
336Type created.
337
338No errors.
339
340Type created.
341
342No errors.
343
344Type created.
345
346No errors.
347
348Type created.
349
350No errors.
351
352Type created.
353
354No errors.
355
356Warning: Type created with compilation errors.
357
358Errors for TYPE MALADIEPATIENTTYPE:
3590/0 PL/SQL: Compilation unit analysis terminated
3603/17 PLS-00532: Target of REF must be a complete or incomplete object
361 type.
362
363
364Warning: Type created with compilation errors.
365
366Errors for TYPE MALADIETRAITEMENTTYPE:
3670/0 PL/SQL: Compilation unit analysis terminated
3683/17 PLS-00532: Target of REF must be a complete or incomplete object
369 type.
370
371
372Type created.
373
374No errors.
375
376Type created.
377
378No errors.
379
380Table created.
381
382
383Sequence created.
384
385
386Trigger created.
387
388No errors.
389
390Table created.
391
392
393Sequence created.
394
395
396Trigger created.
397
398No errors.
399
400Table created.
401
402
403Sequence created.
404
405
406Trigger created.
407
408No errors.
409
410Table created.
411
412
413Sequence created.
414
415
416Trigger created.
417
418No errors.
419
420Table created.
421
422
423Sequence created.
424
425
426Trigger created.
427
428No errors.
429
430Table created.
431
432
433Sequence created.
434
435
436Trigger created.
437
438No errors.
439
440Table created.
441
442
443Sequence created.
444
445
446Trigger created.
447
448No errors.
449CREATE TABLE Patient OF PatientType(
450 *
451ERROR at line 1:
452ORA-00902: invalid datatype
453
454
455
456Sequence created.
457
458CREATE TRIGGER PatientPkeySeq BEFORE INSERT ON Patient FOR EACH ROW BEGIN
459 *
460ERROR at line 1:
461ORA-00942: table or view does not exist
462
463
464No errors.
465CREATE TABLE Maladie OF MaladieType(
466 *
467ERROR at line 1:
468ORA-00902: invalid datatype
469
470
471
472Sequence created.
473
474CREATE TRIGGER MaladiePkeySeq BEFORE INSERT ON Maladie FOR EACH ROW BEGIN
475 *
476ERROR at line 1:
477ORA-00942: table or view does not exist
478
479
480No errors.
481
482Table created.
483
484
485Sequence created.
486
487
488Trigger created.
489
490No errors.
491
492Table created.
493
494
495Sequence created.
496
497
498Trigger created.
499
500No errors.
501
502Table created.
503
504
505Sequence created.
506
507
508Trigger created.
509
510No errors.
511
512Table created.
513
514
515Sequence created.
516
517
518Trigger created.
519
520No errors.
521
522Table created.
523
524
525Sequence created.
526
527
528Trigger created.
529
530No errors.
531
532Table created.
533
534
535Sequence created.
536
537
538Trigger created.
539
540No errors.
541CREATE TABLE MaladiePatient OF MaladiePatientType(
542 *
543ERROR at line 1:
544ORA-00902: invalid datatype
545
546
547
548Sequence created.
549
550CREATE TRIGGER MaladiePatientPkeySeq BEFORE INSERT ON MaladiePatient FOR EACH ROW BEGIN
551 *
552ERROR at line 1:
553ORA-00942: table or view does not exist
554
555
556No errors.
557CREATE TABLE MaladieTraitement OF MaladieTraitementType(
558 *
559ERROR at line 1:
560ORA-00902: invalid datatype
561
562
563
564Sequence created.
565
566CREATE TRIGGER MaladieTraitementPkeySeq BEFORE INSERT ON MaladieTraitement FOR EACH ROW BEGIN
567 *
568ERROR at line 1:
569ORA-00942: table or view does not exist
570
571
572No errors.
573
574Table created.
575
576
577Sequence created.
578
579
580Trigger created.
581
582No errors.
583
584Table created.
585
586
587Sequence created.
588
589
590Trigger created.
591
592No errors.
593INSERT INTO Maladie (Nom, MaladieId) VALUES ('Hépatite', NULL)
594 *
595ERROR at line 1:
596ORA-00942: table or view does not exist
597
598
599INSERT INTO Maladie (Nom, MaladieId) VALUES ('Hépatite alcoolique', (SELECT REF(M) FROM Maladie M WHERE Nom='Hépatite'))
600 *
601ERROR at line 1:
602ORA-00942: table or view does not exist
603
604
605INSERT INTO Maladie (Nom, MaladieId) VALUES ('Hépatite A', (SELECT REF(M) FROM Maladie M WHERE Nom='Hépatite'))
606 *
607ERROR at line 1:
608ORA-00942: table or view does not exist
609
610
611INSERT INTO Maladie (Nom, MaladieId) VALUES ('Hépatite A chronique', (SELECT REF(M) FROM Maladie M WHERE Nom='Hépatite A'))
612 *
613ERROR at line 1:
614ORA-00942: table or view does not exist
615
616
617INSERT INTO Maladie (Nom, MaladieId) VALUES ('Hépatite B', (SELECT REF(M) FROM Maladie M WHERE Nom='Hépatite'))
618 *
619ERROR at line 1:
620ORA-00942: table or view does not exist
621
622
623INSERT INTO Maladie (Nom, MaladieId) VALUES ('Hépatite B chronique', (SELECT REF(M) FROM Maladie M WHERE Nom='Hépatite B'))
624 *
625ERROR at line 1:
626ORA-00942: table or view does not exist
627
628
629INSERT INTO Maladie (Nom, MaladieId) VALUES ('Hépatite C', (SELECT REF(M) FROM Maladie M WHERE Nom='Hépatite'))
630 *
631ERROR at line 1:
632ORA-00942: table or view does not exist
633
634
635INSERT INTO Maladie (Nom, MaladieId) VALUES ('Hépatite C chronique', (SELECT REF(M) FROM Maladie M WHERE Nom='Hépatite C'))
636 *
637ERROR at line 1:
638ORA-00942: table or view does not exist
639
640
641INSERT INTO Patient (Nom, Prenom, DateNaissance) VALUES ('Ismail', 'Manel', DATE '1994-04-14')
642 *
643ERROR at line 1:
644ORA-00942: table or view does not exist
645
646
647INSERT INTO Patient (Nom, Prenom, DateNaissance) VALUES ('Chauvin', 'Antoine', DATE '1995-04-03')
648 *
649ERROR at line 1:
650ORA-00942: table or view does not exist
651
652
653
6541 row created.
655
656
6571 row created.
658
659
6601 row created.
661
662
6631 row created.
664
665
6661 row created.
667
668INSERT INTO MaladieTraitement (MaladieId, TraitementId) VALUES (
669 *
670ERROR at line 1:
671ORA-00942: table or view does not exist
672
673
674INSERT INTO MaladieTraitement (MaladieId, TraitementId) VALUES (
675 *
676ERROR at line 1:
677ORA-00942: table or view does not exist
678
679
680INSERT INTO MaladieTraitement (MaladieId, TraitementId) VALUES (
681 *
682ERROR at line 1:
683ORA-00942: table or view does not exist
684
685
686INSERT INTO MaladieTraitement (MaladieId, TraitementId) VALUES (
687 *
688ERROR at line 1:
689ORA-00942: table or view does not exist
690
691
692INSERT INTO MaladieTraitement (MaladieId, TraitementId) VALUES (
693 *
694ERROR at line 1:
695ORA-00942: table or view does not exist
696
697
698INSERT INTO MaladieTraitement (MaladieId, TraitementId) VALUES (
699 *
700ERROR at line 1:
701ORA-00942: table or view does not exist
702
703
704INSERT INTO MaladieTraitement (MaladieId, TraitementId) VALUES (
705 *
706ERROR at line 1:
707ORA-00942: table or view does not exist
708
709
710INSERT INTO MaladiePatient (MaladieId, PatientId) VALUES (
711 *
712ERROR at line 1:
713ORA-00942: table or view does not exist
714
715
716INSERT INTO MaladiePatient (MaladieId, PatientId) VALUES (
717 *
718ERROR at line 1:
719ORA-00942: table or view does not exist
720
721
722 (SELECT REF(P) FROM Patient P WHERE Prenom='Manel'),
723 *
724ERROR at line 3:
725ORA-00942: table or view does not exist
726
727
728 (SELECT REF(P) FROM Patient P WHERE Prenom='Antoine'),
729 *
730ERROR at line 3:
731ORA-00942: table or view does not exist
732
733
734
7351 row created.
736
737
7381 row created.
739
740
7411 row created.
742
743
7441 row created.
745
746
7471 row created.
748
749
7501 row created.
751
752
7531 row created.
754
755
7561 row created.
757
758
7591 row created.
760
761
7621 row created.
763
764
7651 row created.
766
767
7681 row created.
769
770
7711 row created.
772
773
7741 row created.
775
776
7771 row created.
778
779
7801 row created.
781
782
7831 row created.
784
785
7861 row created.
787
788
7891 row created.
790
791
7921 row created.
793
794
7951 row created.
796
797
7981 row created.
799
800
8011 row created.
802
803
8041 row created.
805
806
8071 row created.
808
809
8101 row created.
811
812
8131 row created.
814
815
8161 row created.
817
818
8191 row created.
820
821
8221 row created.
823
824
8251 row created.
826
827
8281 row created.
829
830
8311 row created.
832
833
8341 row created.
835
836
8371 row created.
838
839
8401 row created.
841
842
8431 row created.
844
845
8461 row created.
847
848
8491 row created.
850
851
8521 row created.
853
854
8551 row created.
856
857
8581 row created.
859
860
8611 row created.
862
863
8641 row created.
865
866
8671 row created.
868
869
8701 row created.
871
872
8731 row created.
874
875
8761 row created.
877
878
8791 row created.
880
881
8821 row created.
883
884
8851 row created.
886
887
8881 row created.
889
890
8911 row created.
892
893
8941 row created.
895
896
8971 row created.
898
899
9001 row created.
901
902
9031 row created.
904
905
9061 row created.
907
908
9091 row created.
910
911
9121 row created.
913
914
9151 row created.
916
917
9181 row created.
919
920
9211 row created.
922
923
9241 row created.
925
926
9271 row created.
928
929
9301 row created.
931
932
9331 row created.
934
935
9361 row created.
937
938
9391 row created.
940
941
9421 row created.
943
944
9451 row created.
946
947
9481 row created.
949
950
9511 row created.
952
953
9541 row created.
955
956
9571 row created.
958
959
9601 row created.
961
962
9631 row created.
964
965
9661 row created.
967
968
9691 row created.
970
971
9721 row created.
973
974
9751 row created.
976
977
978Warning: Type Body created with compilation errors.
979
980Errors for TYPE BODY MEDICAMENTTYPE:
9813/40 PLS-00103: Encountered the symbol ")" when expecting one of the
982 following:
983 <an identifier> <a double-quoted delimited-identifier>
984 current delete exists prior
985
9865/3 PLS-00103: Encountered the symbol "END" when expecting one of the
987 following:
988 ( begin case declare exit for goto if loop mod null pragma
989 raise return select update while with <an identifier>
990 <a double-quoted delimited-identifier> <a bind variable> <<
991 continue close current delete fetch lock insert open rollback
992 savepoint set sql execute commit forall merge pipe purge
993
9947/43 PLS-00103: Encountered the symbol ")" when expecting one of the
995 following:
996 <an identifier> <a double-quoted delimited-identifier>
997 current delete exists prior
998
9999/3 PLS-00103: Encountered the symbol "END" when expecting one of the
1000 following:
1001 ( begin case declare exit for goto if loop mod null pragma
1002 raise return select update while with <an identifier>
1003 <a double-quoted delimited-identifier> <a bind variable> <<
1004 continue close current delete fetch lock insert open rollback
1005 savepoint set sql execute commit forall merge pipe purge
1006
100712/43 PLS-00103: Encountered the symbol ")" when expecting one of the
1008 following:
1009 <an identifier> <a double-quoted delimited-identifier>
1010 current delete exists prior
1011
101214/3 PLS-00103: Encountered the symbol "END" when expecting one of the
1013 following:
1014 ( begin case declare exit for goto if loop mod null pragma
1015 raise return select update while with <an identifier>
1016 <a double-quoted delimited-identifier> <a bind variable> <<
1017 continue close current delete fetch lock insert open rollback
1018 savepoint set sql execute commit forall merge pipe purge
1019
1020
1021Warning: Type Body created with compilation errors.
1022
1023Errors for TYPE BODY MALADIETYPE:
10244/34 PLS-00103: Encountered the symbol ")" when expecting one of the
1025 following:
1026 <an identifier> <a double-quoted delimited-identifier>
1027 current delete exists prior
1028
10296/3 PLS-00103: Encountered the symbol "END" when expecting one of the
1030 following:
1031 ( begin case declare exit for goto if loop mod null pragma
1032 raise return select update while with <an identifier>
1033 <a double-quoted delimited-identifier> <a bind variable> <<
1034 continue close current delete fetch lock insert open rollback
1035 savepoint set sql execute commit forall merge pipe purge
1036
1037
1038Warning: Type Body created with compilation errors.
1039
1040Errors for TYPE BODY PATIENTTYPE:
10416/3 PLS-00103: Encountered the symbol "END" when expecting one of the
1042 following:
1043 ( begin case declare exit for goto if loop mod null pragma
1044 raise return select update while with <an identifier>
1045 <a double-quoted delimited-identifier> <a bind variable> <<
1046 continue close current delete fetch lock insert open rollback
1047 savepoint set sql execute commit forall merge pipe purge
1048
10499/40 PLS-00103: Encountered the symbol ")" when expecting one of the
1050 following:
1051 <an identifier> <a double-quoted delimited-identifier>
1052 current delete exists prior
1053
105411/3 PLS-00103: Encountered the symbol "END" when expecting one of the
1055 following:
1056 ( begin case declare exit for goto if loop mod null pragma
1057 raise return select update while with <an identifier>
1058 <a double-quoted delimited-identifier> <a bind variable> <<
1059 continue close current delete fetch lock insert open rollback
1060 savepoint set sql execute commit forall merge pipe purge
1061
106218/3 PLS-00103: Encountered the symbol "END" when expecting one of the
1063 following:
1064 ( begin case declare exit for goto if loop mod null pragma
1065 raise return select update while with <an identifier>
1066 <a double-quoted delimited-identifier> <a bind variable> <<
1067 continue close current delete fetch lock insert open rollback
1068 savepoint set sql execute commit forall merge pipe purge
1069
107024/3 PLS-00103: Encountered the symbol "END" when expecting one of the
1071 following:
1072 ( begin case declare exit for goto if loop mod null pragma
1073 raise return select update while with <an identifier>
1074 <a double-quoted delimited-identifier> <a bind variable> <<
1075 continue close current delete fetch lock insert open rollback
1076 savepoint set sql execute commit forall merge pipe purge
1077
1078
1079Warning: Function created with compilation errors.
1080
1081Errors for FUNCTION GETINTERACTIONS:
10823/1 PLS-00103: Encountered the symbol "END" when expecting one of the
1083 following:
1084 ( begin case declare exit for goto if loop mod null pragma
1085 raise return select update while with <an identifier>
1086 <a double-quoted delimited-identifier> <a bind variable> <<
1087 continue close current delete fetch lock insert open rollback
1088 savepoint set sql execute commit forall merge pipe purge
1089
1090
1091Warning: Function created with compilation errors.
1092
1093Errors for FUNCTION GETALLINTERACTIONS:
10941/29 PLS-00103: Encountered the symbol ")" when expecting one of the
1095 following:
1096 <an identifier> <a double-quoted delimited-identifier>
1097 current delete exists prior
1098
10993/1 PLS-00103: Encountered the symbol "END" when expecting one of the
1100 following:
1101 ( begin case declare exit for goto if loop mod null pragma
1102 raise return select update while with <an identifier>
1103 <a double-quoted delimited-identifier> <a bind variable> <<
1104 continue close current delete fetch lock insert open rollback
1105 savepoint set sql execute commit forall merge pipe purge
1106
1107
1108Warning: Function created with compilation errors.
1109
1110Errors for FUNCTION GETDEVELOPEDONLY:
11111/27 PLS-00103: Encountered the symbol ")" when expecting one of the
1112 following:
1113 <an identifier> <a double-quoted delimited-identifier>
1114 current delete exists prior
1115
11163/1 PLS-00103: Encountered the symbol "END" when expecting one of the
1117 following:
1118 ( begin case declare exit for goto if loop mod null pragma
1119 raise return select update while with <an identifier>
1120 <a double-quoted delimited-identifier> <a bind variable> <<
1121 continue close current delete fetch lock insert open rollback
1122 savepoint set sql execute commit forall merge pipe purge
1123
1124
1125Warning: Function created with compilation errors.
1126
1127Errors for FUNCTION GETSTRICTLYDEVELOPEDONLY:
11281/35 PLS-00103: Encountered the symbol ")" when expecting one of the
1129 following:
1130 <an identifier> <a double-quoted delimited-identifier>
1131 current delete exists prior
1132
11333/1 PLS-00103: Encountered the symbol "END" when expecting one of the
1134 following:
1135 ( begin case declare exit for goto if loop mod null pragma
1136 raise return select update while with <an identifier>
1137 <a double-quoted delimited-identifier> <a bind variable> <<
1138 continue close current delete fetch lock insert open rollback
1139 savepoint set sql execute commit forall merge pipe purge
1140
1141Disconnected from Oracle Database 11g Express Edition Release 11.2.0.2.0 - 64bit Production