DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: errors

Hybrid View

  1. #1
    Join Date
    Dec 2000
    Posts
    62

    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

  2. #2
    Join Date
    Aug 2002
    Location
    Colorado Springs
    Posts
    5,253
    delete lines 43 and 65
    David Aldridge,
    "The Oracle Sponge"

    Senior Manager, Business Intelligence Development
    XM Satellite Radio
    Washington, DC

    Oracle ACE

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width