1 2 3 4 5 6 7 8 9
| -- création de la table d'import
commande:='create table IMPORT_TMP (ID_PANO INTEGER,X FLOAT,Y FLOAT,altitude float,yaw float,pitch float,roll float,date_data varchar2(50),sky_cover float) ';
commande:= commande || ' ORGANIZATION EXTERNAL ( TYPE oracle_loader DEFAULT DIRECTORY MYREP ACCESS PARAMETERS (';
commande:= commande || ' RECORDS DELIMITED BY NEWLINE';
commande:= commande || ' SKIP 1';
commande:= commande || ' FIELDS TERMINATED BY ''\t''';
commande:= commande || ' MISSING FIELD VALUES ARE NULL ) LOCATION (' || :nom || ') ) REJECT LIMIT 0 NOMONITORING;';
EXECUTE commande; |
Partager