# Url problem

**URL:** <https://www.ruby-forum.com/t/url-problem/164822>\
**Category:** Rails\
**Created:** [April 6, 2009, 11:30am UTC](https://www.ruby-forum.com/t/url-problem/164822 "2009-04-06T11:30:21Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![vaibhav\_darji](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/v/a4c791/32.png) [@vaibhav\_darji](https://www.ruby-forum.com/u/vaibhav_darji)\
**Post date:** [April 6, 2009, 11:30am UTC](https://www.ruby-forum.com/t/url-problem/164822/1 "2009-04-06T11:30:21Z")

</div>

I contain oracle as my database  
having table “oratest11”,contails 2 fields as  
(id\_field(Number),data(varchar2(20)) a sequence as “oratest11\_seq” which  
is incrementing the value of id\_field

My model is as follows:-

class Oratest11 \< ActiveRecord::Base  
set\_table\_name ‘oratest11’  
set\_primary\_key ‘id\_field’  
end

My Controler is as follows:-

class Oratest11sController \< ApplicationController  
def index  
@oratest11s=Oratest11.find(:all)  
end

def show  
@oratest11=Oratest11.find(params[:id])  
end

Index view:-

 \<% for ora in @oratest11s %\> 

```
    <td><%=h ora.data %>
  </td>

```

\<% end %\>

| \<%=h ora.id\_field %\> | \<%= link\_to 'show',:action=\>'show',:id=\>ora %\> |

Show View:-

| \<%= @oratest11.data %\> | \<%= @oratest11.id\_field %\> |

When i click on the show hiperlink error comes:-

Template is missing  
Missing template oratest11s/show.erb in view path app/views

But when i used  
default:-  
[http://localhost:3000/oratest11s/show/1.0](http://localhost:3000/oratest11s/show/1.0)  
Instade Used:-  
[http://localhost:3000/oratest11s/show/1](http://localhost:3000/oratest11s/show/1)  
it works fine…

so what could i used and how to directly go, after clicking the “view”  
hiperlink:-  
[http://localhost:3000/oratest11s/show/1](http://localhost:3000/oratest11s/show/1)

when, i change datatype of id\_field as Number to Integer it works  
fine…  
but, i dont want to change the datatype of id\_field sence it contains  
lots of records.