On Wed, 21 Jan 2004, Christian Schulz wrote: > Hi, > > trying the access to Oracle via ODBC in Win2k/1.8.1 i have only 2 problems. > (1) number(x,y) formats in oracle result in R-Project as a factor with more > than 20.000 levels for every distinct value. > My coversion attempts until now failed, i.e. as.numeric(money) result > in a: > Error in as.double.default(money) : (list) object cannot coerced to double
Presumably money is a data frame. See the FAQ on how to convert a factor to numeric (hint: not by as.numeric). > (2) A attempt to save a data.frame result in a: > Error in sqlSave(channel,SAVETTEST,colnames=T) > Missing column name > Check case conversion parameter in odbcConnect > > Now i see the table with headers and without rows in oracle. Did you do the check you were asked to? You have the R code (and indeed the C sources), and we don't have an Oracle ODBC client (nor have you told us what you are using). It really isn't hard for an end-user to debug this sort of thing. -- Brian D. Ripley, [EMAIL PROTECTED] Professor of Applied Statistics, http://www.stats.ox.ac.uk/~ripley/ University of Oxford, Tel: +44 1865 272861 (self) 1 South Parks Road, +44 1865 272866 (PA) Oxford OX1 3TG, UK Fax: +44 1865 272595 ______________________________________________ [EMAIL PROTECTED] mailing list https://www.stat.math.ethz.ch/mailman/listinfo/r-help PLEASE do read the posting guide! http://www.R-project.org/posting-guide.html
