Unable to destroy object - Oracle adapter

Rails
1

Hi all,
I am now able to create, update and list object from oracle database
(local XE) without any problems. But the destroy method is not
working.
It is given me this error
undefined method `destroy’ for #Array:0xcbc9b68

I am using
ruby 1.8.7
rails 2.3.11
activerecord-oracle-adapter
ruby-oci8 1.0.6

Is there setting I should put in corresponding model, like constrains
or something.
I also added
set_table_name and set_primary_key to the model, which has number of
has_many relations.

Any help will be appreciated.

Cheers,
Fiz

2

On Apr 24, 3:21pm, fAisAl [email protected] wrote:

Hi all,
I am now able to create, update and list object from oracle database
(local XE) without any problems. But the destroy method is not
working.
It is given me this error
undefined method `destroy’ for #Array:0xcbc9b68

Sounds like you’re calling destroy on the wrong thing (probably an
array of objects from your db rather than an object itself.

Fred

3

Thanks Fred for your reply.
I print the size before destroying the object, it gives me 1.
And also I am able to print the content of the object without
using .each for looping, thats mean it still object.

Before that error, I used to get errors with object id.
I named the object primary key as “objectid” in database.
The error I used to get is concern not finding id attribute in table.

Is it possible to be the problem that I did not follow Activerecord
conventions.

Cheers,
Fiz

On Apr 24, 11:39pm, Frederick C. [email protected]

4

On Apr 24, 4:04pm, fAisAl [email protected] wrote:

Thanks Fred for your reply.
I print the size before destroying the object, it gives me 1.
And also I am able to print the content of the object without
using .each for looping, thats mean it still object.

I can only guess without seeing what you’re doing, but that really
does sound like you’re calling destroy on a collection rather than on
an individual object.

Fred

5

On 24 April 2011 16:04, fAisAl [email protected] wrote:

Thanks Fred for your reply.
I print the size before destroying the object, it gives me 1.

If object.size is 1 then it is probably an array of length 1. size is
not defined for a single ActiveRecord object.

And also I am able to print the content of the object without
using .each for looping, thats mean it still object.

How are you printing the content of the object? Are you sure it is
not displaying with square brackets round it to indicate that it is an
array.

Colin

Before that error, I used to get errors with object id.
I named the object primary key as “objectid” in database.

I hope your object is not actually of class Object otherwise you will
be in trouble I fear.

The error I used to get is concern not finding id attribute in table.

Is it possible to be the problem that I did not follow Activerecord
conventions.

I always advise sticking to the conventions unless there is a good
reason for not doing so. You will save yourself grief.

Colin

6

Thank you again Fred, I will try to solve the problem and see whether
it is a collection or an individual object.
Again thank you for your help, I really appropriate it.

Cheers,
Fiz

On Apr 25, 12:34am, Frederick C. [email protected]