-
errors
can some one plllllllllllllllz help me
SQL> declare
2 cursor cur_insertrow is
3 select
4 b.fyi_lab_report,
5 a.fyi_reference_id,
6 a.fyi_title,
7 a.fyi_first_name,
8 a.fyi_last_name,
9 a.fyi_position,
10 c.sys_author,
11 a.fyi_address1,
12 a.fyi_city,
13 a.fyi_state,
14 a.fyi_postal_code,
15 a.fyi_phone,
16 a.fyi_received_date,
17 b.fyi_approval_date,
18 b.fyi_un_number,
19 b.fyi_un_haz_class,
20 b.fyi_product_desc,
21 b.fyi_ship_name,
22 b.fyi_haz_class,
23 b.fyi_notes,
24 b.fyi_expiration_date
25 from fyiadm.Fyi_ohma_wf a,fyiadm.fyi_ohma_doc
26 b,fyiadm.fyi_sysdata c
27
28 where
29 fyi_project_status not like '1032%'
30 and
31
32 (b.sys_fkey = a.sys_fkey);
33
34 begin
35
36 --EXECUTE IMMEDIATE('TRUNCATE TABLE DATASET_EXPLO');
37 --COMMIT;
38
39 for var_insertrow in cur_insertrow
40 loop
41
42 insert into dataset_explo(
43 select
44 lab_report_no,
45 reference_number,
46 contact_title,
47 contact_first_name,
48 contact_last_name,
49 contact_position,
50 cotact_company,
51 contact_address,
52 contact_city,
53 contact_state,
54 contact_zip,
55 contact_phone,
56 received_date,
57 national_stock_number,
58 un_proper_shipping_name,
59 un_serial_number,
60 product_name,
61 shipping_name,
62 hazard_class,
63 un_name_massage,
64 expire_date
65 from dataset_explo;
66 )
67 values(
68 var_insertrow.fyi_lab_report,
69 var_insertrow.fyi_reference_id,
70 var_insertrow.fyi_title,
71 var_insertrow.fyi_first_name,
72 var_insertrow.fyi_last_name,
73 var_insertrow.fyi_position,
74 var_insertrow.sys_author,
75 var_insertrow.fyi_address1,
76 var_insertrow.fyi_city,
77 var_insertrow.fyi_state,
78 var_insertrow.fyi_postal_code,
79 var_insertrow.fyi_phone,
80 var_insertrow.fyi_received_date,
81 var_insertrow.fyi_approval_date,
82 var_insertrow.fyi_un_ship_name,
83 var_insertrow.fyi_un_number,
84 var_insertrow.fyi_un_haz_class,
85 var_insertrow.fyi_product_desc,
86 var_insertrow.fyi_ship_name,
87 var_insertrow.fyi_haz_class,
88 var_insertrow.fyi_notes,
89 var_insertrow.fyi_expiration_date);
90
91
92
93
94
95 If MOD(Cur_insertrow%ROWCOUNT,5000) = 0
96 THEN
97 COMMIT;
98 End if;
99 End Loop;
100 commit;
101 end;
102 /
b.fyi_haz_class,
*
ERROR at line 22:
ORA-06550: line 65, column 19:
PL/SQL: ORA-00907: missing right parenthesis
ORA-06550: line 42, column 11:
PL/SQL: SQL Statement ignored
ORA-06550: line 66, column 16:
PLS-00103: Encountered the symbol ")" when expecting one of the following:
begin case declare end exit for goto if loop mod null pragma
raise return select update while with
-
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|