thanks Tiffany for providing the url for ref. still i am trouble with the
following error in my script execution.
C:/build/ruby-oci8-2.0.3/ext/oci8/stmt.c:306:in oci8lib.so: ORA-00942: table
or view does not exist (OCIError)
from
C:/Ruby/lib/ruby/gems/1.8/gems/ruby-oci8-2.0.3-x86-mswin32-60/lib/oci8/oci8.rb:287:in
`exec'
from test3.rb:13
from test3.rb:10:in `times'
from test3.rb:10
my script is:
require 'oci8'
conn = OCI8.new('lup', 'es104', '//192.168.2.3:1521/ORCL')
i=10
cursor = conn.parse('insert into temp values (:id,:name)')
100.times {
cursor.bind_param(':id',i)
cursor.bind_param(':name',"Name #{i}")
cursor.exec
i +=1
}
cursor.close
conn.commit
cursor = conn.exec('SELECT id,name from TEMP');
while r = cursor.fetch
puts " ID: #{r[0]} = #{r[1]}"
end
cursor.close
conn.logoff
MY script details:
Watir
Oci8
functionality: login to my application (login_id and login_password are
variables)
my oracle table contains users table with column names login_id,
login_password
i am trying insert the login, password field to temp table and binding as
strings to pass the variable to my login script.
I appreciate if anyone corrects the script to make it pass.
thanks,
venky
On Tue, Nov 24, 2009 at 8:44 PM, Tiffany Fodor <tcfo...@comcast.net> wrote:
>
> Hi Venky!
>
> If you were looking at my example Test::Unit harness:
>
>
> http://wiki.openqa.org/display/WTR/Test+Unit+Excel+Data+Driven+Framework+with+Database+Verifications
>
> DataVerification.rb connects to SQL and Oracle, retrieves value using
> select statements and verifies then against an expected value. You
> could also use this to retrieve test data once it's populated in your
> database.
>
> If this doesn't do what you need it to, you may want to look into
> using the ActiveRecord class. Note that ActiveRecord is it's own Ruby
> project, not part or Watir. I'm moving that way myself, as
> ActiveRecord seems more solid than the DBI class.
>
> Hope this helps!
>
> -Tiffany
>
> On Nov 24, 2:44 am, venkat <greet.ven...@gmail.com> wrote:
> > Hi,
> >
> > I am venkat, started using watir for the last 3 to 4 weeks. I understand
> > basic watir scripting since opening of the browser to navigating pages by
> > identifying the elements etc. and I feel WATiR is an excellent tool. Also
> I
> > have gone through the datadriven framework with excel data examples.
> >
> > I have searched in google for examples, blogs, code snippets for a
> framework
> > that built using watir with sql server or watir with oracle but failed to
> > get it. I can see the test code to establish connections from watir to
> sql
> > dbi or oracle but further details are not much.
> >
> > At this point I request you to please help me out in finding a good
> > framework that uses watir with sql or oracle database that can be
> re-usable
> > with modifications kind of.
> >
> > I appreciate if any one helps.
> >
> > Thanks and hope to see your mail.
> >
> > Regards,
> > Venky
> >
>
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"Watir General" group.
To post to this group, send email to watir-general@googlegroups.com
Before posting, please read the following guidelines:
http://wiki.openqa.org/display/WTR/Support
To unsubscribe from this group, send email to
watir-general-unsubscr...@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/watir-general
-~----------~----~----~----~------~----~------~--~---
