similar to: What's the trick for using CLOB values (Oracle)?

Hi everyone, I have been following these forums closely for the last few months but this is my first time posting. Basically I am trying to get an Oracle SQL Developer Binary Large Object(BLOB/CLOB) file in as an R object in R. For those not familiar with a BLOB/CLOB file, it is basically lik a table that has cells that contain tables or files. By converting the large table into a BLOB/CLOB file

We recently switched to Rails 1.1.2, which includes the latest version of ActiveRecord. This version seems to have introduced an error with the handling of non-binary large objects. The OCI adapter in 1.13.2 seemed to have treated CLOB and BLOB identically. The new Oracle adapter distinguishes between the two types and gives CLOB a type of :text, where as BLOB are :binary When it comes to

I have a field that is a clob within an Oracle database on Rails 0.13. Things have been working well until I tried to submit the field empty via a rails app at which point the following error was returned: ORA-24801: illegal parameter value in OCI lob function /app/controllers/publications_controller.rb:64:in `update'' The line in question was: if

Hello, I have been searching for it but could not find anything on Oracle different servers. Maybe someone here will be able to answer this question : Are CLOB and SYS.XML data type supported by OCFS? We need to migrate a 9.2.0.4 Windows Database having these data types to a 9.2.0.4 Linux Real Application Cluster with OCFS. This could cause an issue. Thanks in advance Philippe

The revised patch submitted on #4748 broke the build, I''m looking to sort out why. Also note that this auto-test email didn''t make it to rails-core because it was too big (every test failed, so the resulting email was huge). I''ll patch my auto-testing script to truncate the email to no larger than a few kb. Michael Schoen wrote: > "marcel" made

Hi, maybe this is of use for some of you. RailsCron from http://svn.kylemaxwell.com/rails_cron/trunk does not work with an Oracle database out of the box. One thing is the usage of "start" as an attribute name, which is a reserved word in Oracle. The other thing is the datatype :text for the command column. This will become a CLOB which cannot be queried with an ActiveRecord select.

Howdy folks, Has anyone had any luck getting Oracle''s XMLType to play nicely with Rails? According to the docs, it''s just a wrapper around CLOB. However the ruby-oci8 driver throws an exception about user defined types if you try to query a table with an XMLType column. Any pointers would be appreciated. Thanks, -wilig

Has anyone encountered this error or know how to correct it? I couldn''t find any Rails-specific info about this on google. Here are the circumstances: /usr/local/bin/ruby --version ruby 1.8.4 (2005-12-24) [i686-linux] /usr/local/bin/rails --version Rails 1.1.6 ## Create mcd app rails mcd -d oracle cd mcd ## Create oracle tablespace & user sqlplus ''/ as

All, While attempting to use ActiveRecord against a large database, approx. 1700 tables and 4 million rows, I discovered an inefficiency in oci_adapter.rb. The problem seems to be the SQL being generated to lazy-load the columns metadata. "def columns(table_name, name = nil)" method generates the following SQL: select column_name, data_type, data_default, nullable,

Hi, I would like to share a file system (OCFS2) in a shared disk in the SAN for Oracle application servers 10g to share same volume between all Oracle Application servers. I am not sure Is OCFS 2 certified for OAS 10g? I have been using OCFS 2 for Oracle RAC 10g Database which is certified. Pls give your suggestion. All servers are SLES 10 SP2 with Oracle Application Server 10g. Thanks

All, We're currently running Oracle 9i on a RHEL AS 2.1 installation. We need to upgrade to Oracle 10g, and I've half-way convinced my boss to upgrade to RHEL 4 (we're still discussing AS vs ES, since we're running 2 HT processors...). Anyway, I want to upgrade because of EOL issues whenever RHEL 5 comes out, but before he okays me wiping the server and installing 4, he

Hi, I am new to R. I need to communicate with Oracle from R program in windows xp. So I am planning to use ROracle. I downloaded the ROracle src from the site below: http://cran.r-project.org/web/packages/ROracle/index.html I am using R version 2.6.2 and Oracle 10g. I followed the instructions to build ROracle. When I try to compile the source src/Makefile.win I get the following error:

Hello llist! I have Centos 5.2 installed! Would like to use Oracle on it.So I downloaded Oracle Apllication server 10g rel. 3. We need to develop and use Oracle Forms applications. Do we need to install 10g Developer Suite also or are the forms contained in the application server? If we need the Developer Suite also , please tell us where from to download it. Thanks

Anyone know what''s up with the activerecord session store when using the oracle adapter in Rails 2.0.2 ? I can set a session variable and can then see it''s actually set using the debugger, but after the request completes the session is empty (the @data member is nil). The session_id is staying the same and the updated_at field is being updated but nothing I put in a session

Hola, ¿alguien sabe como actualizar un campo de oracle desde R con el paquete ROracle? Aquí el problema es el tipo de dato de la tabla, el cual no puede cambiar, es clob. Tampoco el paquete de R puede ser otro. Necesito poner un texto muy grande. He buscado en google he intentado con stored procedure y no funciona. Se trata de un proceso que debe quedar automatizado. Muchas gracias

Hello, I installed RGui 2.5.1 and package DBI on Windows XP and tried to connect to Oracle database which is on a Linux server. When I tried to use dbDriver("Oracle"), I got an error as follows: > drv <- dbDriver("Oracle") Error in do.call(as.character(drvName), list(...)) : could not find function "Oracle" > Could anyone tell me how

Hi, I've tried to install Oracle Database 10g on CentOS but installation doesnt start saying op. system should be RHEL 3, SUSE 9.0... (or upper) etc. does anyone knows how to install Oracle Database 10g on CentOS. Should I modify runinstall script? Thanks.

Yesterday night I've tuned F7 DomU for Oracle 11g install successfully installed Oracle , made checks for EM Console and shutdown DomU. Today morning :- # xm start FDR7PVM # xm console FDR7PVM Fedora release 7 (Moonshine) Kernel 2.6.20-2925.9.fc7xen on an x86_64 Server11G login: root Password: Module is unknown Fedora release 7 (Moonshine) Kernel 2.6.20-2925.9.fc7xen on an x86_64

An HTML attachment was scrubbed... URL: http://oss.oracle.com/pipermail/ocfs2-users/attachments/20060315/9e72c36b/attachment.html

It seems to be quite an issue to get an Oracle 10g client running on Fedora 5 (FC5) Linux. Does rails (or active record to be more concise) really need the full (300 MB) Oracle client or is this small easy-to-install Oracle-Instant-Client sufficient? Or is there a pure-Ruby solution that works without any Oracle-client installation? Best regards Karl