similar to: Stored procedures (Oracle) and ROR

I work for a small university and am new to rails. We currently have some legacy applications written by folks who no longer work here in .NET and the like. We are looking to rebuild these apps and are thinking about RoR. Our biggest concern is our database backend. We have an incredibly complicated, convoluted, and old student information system built on Oracle. To pull various pieces

Hi, I have a question about bundle: RoR + oracle + bind variables. Heaving read forums/blogs/etc I found out RoR does not use bind vars for oracle particularly (and for all adapters in general). Then I found Michael''s patch (http://dev.rubyonrails.org/attachment/ticket/5199/oracle_bind.patch) but it was not added to the following RoR versions (since the end of May). As I suppose it was

Does ROR + Oracle use bind variables? Using :conditions in a find statement gives the appearance that bind variables might be used : header = "test header" Posts.find(:all,:conditions=>["header = ?",header]) i.e. Does AR just pass the whole string to oracle or the SQL and the parameters? I''m in an oracle shop and my boss wants to know, i''d be very

Hi, Is anyone using Oracle with RoR successfully? Is everything running smoothly? What are the main issues? any response is appreciated thanks, Chris -- Posted via http://www.ruby-forum.com/.

In my opinion most mature/complex client/server or n-tier applications using SQL Server, Oracle, or MySQL, use stored procedures. Without support (except by use of the execute method) for Stored Procedures, Ruby on Rails or MonoRail is a Show Stopper. We are unable to effectively use Ruby On Rails as all access to the db is using Stored Procedures. This does not mean that we are unable to use

Hi Experts, I''ve a model called Product where i''ve column called created_at, updated_at where i''ve made a query based on Oracle date format like date_of_created = ''23-SEP-07'' @product = Product.find(:all, :conditions => ["created_at=?", date_of_created]) but in view its empty. AND EXPERTS I''VE DATA WITH 24-SEP-07 FOR MORE

Hi all, I know stored procedures are considered evil around, but there are times when you just have to use them. In the project I''m working on, I needed to call a mysql5 stored procedure, but I only got an error message saying "ActiveRecord::StatementInvalid: Mysql::Error: PROCEDURE vc.testsp can''t return a result set in the given context: call testsp()" I found out

Hi. Although an expert developer for IBM systems (iSeries) I am VERY new to RoR and somehow to the PC development world as well and not familiar AT ALL with PC configurations, etc. (in my regular job good ol'' IBM takes care of all that and I just need to code). So forgive me if any of the following sounds stupid, it probably is. Just get a laugh at my expense and try to answer between

Hey fellows, I am a novice to ruby and ror, but really addicted to it. As a graduate student, I need master thesis topic around Ruby aor ROR. Can anyone suggest some for me? Regards/Buyan -- You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group. To post to this group, send email to

I am new to RoR, but totally sold to the concepts, so I have decided to use RoR to develop a web client to our Oracle-based software that our customers today use with a Windows client. At first we will develope simple things like registering to receive email newsletters, and registering/updating your name, address and telephone etc. Eventually we hope to do a more full-bodied web-side client.

Dear users, I can access an database oracle database using sql developer. This was done by importing an xml file that contains the login details - username, password and specifies that it uses the KERBEROS_AUTHENTICATION. I'm trying to connect R - so that it can access this database - do sql queries and convert the resulting tables into dataframes. I am a novice in SQL and database access

Hi Experts I''ve a product like this ID -> 1 Name -> Xyz Price -> 30 Created_at -> 02-NOV-07 from_date = Date.new(2, 10, 07) to_date = Date.new(2, 10, 07) @product = Product.find_by_sql("select * from products where created_at between from_date and to_date") code works perfectly, buy my issue is i dont get any data. always says no record found but if i use

Are you NZ based (or in the process of relocating) and a Ruby on Rails and/or Oracle Application Express guru?? Then read on…… We are on the look out for people with the following technical skills ROR Developers: Ruby on Rail SQL Unix/Linux HTML/CCS/Javascript Oracle Apex Developers: SQL HTML/CSS/Javascript Working knowledge of RAD

Folks, I am using ruby 1.8.5 with rails 1.2.3 and have made changes to mysql_adapter.rb based on recommendations made here http://wiki.rubyonrails.org/rails/pages/StoredProceduresInMySql to be able to use stored procs in my code. I have changed this call in mysql_adapter.rb ConnectionAdapters::MysqlAdapter.new(mysql, logger, [host, username, password, database, port, socket], config) to

Hello, I''m having a trouble when I try to connect RoR and Oracle. I believe that it has something to do with database.yml, this is how my database.yml looks: development: adapter: oci database: 127.0.0.1:1521/XE username: system password: y1984nip0359 host: 127.0.0.1 And this is the Error that i get: -> http://127.0.0.1:3000/blog OCIError in BlogController#index

Hello all. I am a novice Ruby on Rails programmer, starting my first project using a legacy Oracle 10 database. Using ''reverse_scaffold'' I have created the models/controllers/views for my existing Oracle tables. All seems to work well, using /model/index, /model/show for most of my tables, *except* when one of the tables contains a Oracle ''date'' column, for

Hi, I use RMySQL to connect to MySQL server where I have a couple of stored procedures. I know that the function for the stored procedures "is not yet implemented", but I was trying to get around the problem connecting like that: drv <- dbDriver("MySQL") con <- dbConnect(drv,user=MyUser, password=MyPasswd, dbname=MyDBName, host=MyHost, client.flag="196608"

Hi all, I wonder how can I solve in RoR the problem of accessing a simple table because the URL http://localhost:3000/customers/show/2.0 is raising an Oracle error OCIError: ORA-01722: invalid number. The reason of this error is because the SELECT statement generated by ActiveRecord tries to invoke the id column as a VARCHAR : "... FROM customers WHERE customers.id =

We are working with a client on the following Developer opportunity... • J2EE and/or Ruby on Rails (RoR) • At least one of the following databases: DB2, SQL Server, or Oracle • Minimum 3 years experience • Responsible for UI development • Employment type: Permanent • Location: Greenville, SC (relo provided) If this opportunity interests you, or if you would like to know about other

Hello folks. I''m new in Ruby also ROR. I installed oracle intant client and test it it works fine. Now I wanna connect to oracle db. But its got some error. like this *custom_require.rb:36:in `require'': cannot load such file -- oci8 (LoadError)* my code is here. require ''oci8'' oci =