Posted By: BigFoot (In Your Room) on 'CZdatabases'
Title:     Oracle newbie Q2
Date:      Mon Dec 11 14:52:40 2000

Zdar
Snazim se dostat do Oracla z textaku nejaky "data" (ucim se, takze to neni nic 
zavazneho :).

Takhle vypada tabulka, do ktere to sypu:

Name                                                  Null?    Type
----------------------------------------------------- -------- -------------
ALBUM_ID                                              NOT NULL NUMBER(3)
FILENAME                                              NOT NULL VARCHAR2(255)
TITLE                                                 NOT NULL VARCHAR2(100)
IMAGE_0                                                        VARCHAR2(255)
IMAGE_1                                                        VARCHAR2(255)
IMAGE_2                                                        VARCHAR2(255)
IMAGE_3                                                        VARCHAR2(255)

Album_id je PRIMARY KEY.
Tohle je muj albums.ctl:

LOAD DATA
INFILE *
INTO TABLE albums
REPLACE
FIELDS TERMINATED BY 't' TRAILING NULLCOLS
(album_id CHAR,
filename CHAR,
title CHAR)
BEGINDATA
0 t Antiloop @ Fastlane People.m3u t Fastlane People
1 t ATB @ Movin' Melodies.m3u t Movin' Melodies
2 t Beastie Boys @ Ill Communication.m3u t Ill Communication
...

Tam, kde vidite "t", MAM v souboru samozrejme TAB; misto "CHAR" u album_id
jsem zkousel i "INTEGER EXTERNAL", "NUMBER(3).
Nic se "samozrejme" nevlozi a tohle je kousek z logu:

   Column Name                  Position   Len  Term Encl Datatype
------------------------------ ---------- ----- ---- ---- ---------------------
ALBUM_ID                            FIRST     *   t       CHARACTER            
FILENAME                             NEXT     *   t       CHARACTER            
TITLE                                NEXT     *   t       CHARACTER            

Record 1: Rejected - Error on table ALBUMS, column ALBUM_ID.
ORA-01722: invalid number

Help PLZ.

BigFoot, aka Yaroukh; yaroukh@email.cz
"Budiz svetlo", rekl Booh - a bylo svetlo ...
"Budiz k nicemu", rekl Booh - and here I am !
8}__ __ _

Search the boards