consult BD oracle

rubyonrails-talk
#1

hello everyone, the problem is the following application and made his
and it works very well with mSQL, but I need to consult a table that is
in
oracle, then add to consult the same table in a field
different and Oracle made this just can not show on
my view is the field that I need to say that the data already inside ..
and conultado
ROR several tutorials and books and could not solve ..

thanks in advance.

#2

I'm not sure I understand:

You're using MySQL.
You want to read a value from a field in an Oracle database.
You want to put that value into a different field on the same Oracle
table?
You want to display the result in a view?

Is this correct?

#3

correct!
This is the model for q Cree consultation:

class Re_tmtinv <ActiveRecord:: Base

    establish_connection (
        : adapter => "oracle"
        : host => "localhost"
        : username => "root",
        : password => "*****",
        : database => "*****"
        )
# Validations

   validates_uniqueness_of: mtin_mtin,: message => "The code that this
trying to view does not exist in the system. "

      end

but still can not get the view mostralo q e created.

perhaps a problem in my view.

Thanks for the help.
Greetings.

#4

Wait, by "view" do you mean an Oracle view (like a table) or a Rails
view (like an erb template)