search for: varchar2

We are using MFC/R2 driver successfully in at least three places in Brazil. I have problem with an Asterisk integrated with MFC/R2 with a Siemens Hicom 300. I can get a good audio quality with Grandstream, Polycom, and X-Lite softfones, but SIPURAS and Linksys get a garbled audio, something like a "Darth Vader" voice. We have tried everything in Sipura. The SIPURA 2000 and the Linksys

I rememeber seeing an article about how to cope with legacy databases where the primary key is defined as VARCHAR2. I only want read-access to the data. Does anyone have a link to such an article? Or can give advice? -- Posted via http://www.ruby-forum.com/.

...ains this table: SQL> describe dls_grids; Name Null? Type ----------------------------------------- -------- ---------------------------- ID NOT NULL NUMBER(38) LSD VARCHAR2(2) SECTION VARCHAR2(2) TOWNSHIP VARCHAR2(3) RANGE VARCHAR2(2) MERIDIAN VARCHAR2(2) LATITUDE_MIN...

...ement = paste("select * from cat")) > summary(rs, verbose=TRUE) <OraResult:(6721,7,2)> Statement: select * from cat Has completed? no Affected rows: 0 Rows fetched: -1 Fields: name Sclass type len precision scale isVarLength nullOK 1 TABLE_NAME character VARCHAR2 30 0 0 TRUE FALSE 2 TABLE_TYPE character VARCHAR2 11 0 0 TRUE TRUE > > myContent <- fetch(rs, n = -1) > myContent [1] TABLE_NAME TABLE_TYPE <0 rows> (or 0-length row.names) > summary(myContent, verbose=TRUE) TABLE_NAME TA...

...t.column "email", :string t.column "note", :text end And everything works fine, but in development, it has to run this query for each view select column_name, data_type, data_default, nullable, decode(data_type, ''NUMBER'', data_precision, ''VARCHAR2'', data_length, null) as length, decode(data_type, ''NUMBER'', data_scale, null) as scale from user_catalog cat, user_synonyms syn, all_tab_columns col where cat.table_name = ''USERS'' and syn.synonym_name (+)= cat.table_name and col.table_name = nvl(sy...

Hi I run Ruby on Rails on Oracle XE. I have a simple table: create table customer(id number primary key, name varchar2(100)); And ruby script\generate model Customer ruby script\generate controller Customer http://localhost:3000/customer/ - show a fine list, but when I click show/edit/destroy, I get an ORA-01722: OCIError: ORA-01722: invalid number: select * from (select raw_sql_.*, rownum raw_rnum_ from (SE...

Hi, after some experience with Rails on MySQL databases I gave it a try on one of our larger Oracle database. I was facing a problem when Rails tried to detect the columns for a model/table. The appropriate statement ran about 1 min which led to a timeout. Our Oracle guru told me to analyze the SYSTEM schema. After that hadn''t helped, he said the only remaining chance is to use a

...9; RZFR') > 0 / The table: ---------- SQL> desc snap.vwmt_profil_match_a_fh Name Null? Type ----------------------- -------- ---------------- ABO_ID NOT NULL NUMBER(11) ABO_PHO NUMBER ABO_PAYS VARCHAR2(4) ABO_REGION NUMBER(11) ABO_DEPARTEMENT NUMBER(11) ABO_VILLE NUMBER(11) ABO_CP VARCHAR2(50) PROF_AGE NUMBER(4) PROF_STATUT NUMBER(11) PROF_TAILLE...

...9; RZFR') > 0 / The table: ---------- SQL> desc snap.vwmt_profil_match_a_fh Name Null? Type ----------------------- -------- ---------------- ABO_ID NOT NULL NUMBER(11) ABO_PHO NUMBER ABO_PAYS VARCHAR2(4) ABO_REGION NUMBER(11) ABO_DEPARTEMENT NUMBER(11) ABO_VILLE NUMBER(11) ABO_CP VARCHAR2(50) PROF_AGE NUMBER(4) PROF_STATUT NUMBER(11) PROF_TAILLE...

...; <OraResult:(6721,7,2)> > > Statement: select * from cat > > Has completed? no > > Affected rows: 0 > > Rows fetched: -1 > > Fields: > > name Sclass type len precision scale > isVarLength nullOK > > 1 TABLE_NAME character VARCHAR2 30 0 0 > TRUE FALSE > > 2 TABLE_TYPE character VARCHAR2 11 0 0 > TRUE TRUE > > > >> > >> myContent <- fetch(rs, n = -1) > >> myContent > >> > > [1] TABLE_NAME TABLE_TYPE > > <0 rows&...

I am getting "DESC CYCLEMSTR" failed; does it exist? errors on a table named CYCLEMSTR in Oracle every 3 out of 4 trys to do a simple find(:all) on the table. It is a legacy table that only contains 12 rows of join information. I don''t understand why it works one out of every 4 or 5 times help please. trace: (eval):3:in `describe''

...ue}) rake aborted! An error has occurred, all later migrations canceled: OCIError: ORA-00972: identifier is too long: CREATE TABLE "OPEN_ID_AUTHENTICATION_ASSOCIATIONS" ("ID" NUMBER NOT NULL PRIMARY KEY, "ISSUED" NUMBER, "LIFETIME" NUMBER, "HANDLE" VARCHAR2, "ASSOC_TYPE" VARCHAR2, "SERVER_URL" BLOB, "SECRET" BLOB) /opt/redmine-1.1.2/vendor/rails/activerecord/lib/active_record/connection_adapters/abstract_adapter.rb:219:in `log'' /usr/local/lib/ruby/gems/1.8/gems/activerecord-oracle_enhanced-adapter-1.3.2/lib/activ...

...Null? Type ----------------------------------------- -------- ---------------------------- ID NOT NULL NUMBER(38) AMW NUMBER GVK_ID VARCHAR2(255) PARENT_ID NUMBER ISM_PARENT_ID NUMBER REF_ID NUMBER MECHANISM_ID NUMBER ISM...

...-data.frame(NR=c(1,2,600),NAME=c("JK","TR","AR"), DATUM=c("2009-01-01","2010-01-02","2010-06-09")) If I create the table in the database with sqlSave all is okay. sqlUpdate works fine and the update happens, but "DATUM" is "VARCHAR2". Is there a possibility with RODBC to adjust the format according to my preferences? In my opinion the problem is the format of the variable "DATUM." If I create the table manually in the oracle database and define data type "DATE" for "DATUM", I receive a error...

...the schema definition from migrations to the model, where it should be? Like og does, which I think is used by the ruby Nitro framework... ObjectGraph: http://www.rubygarden.org/index.cgi/Libraries/og_tutorial.rdoc Example code: [code] class Post property :title, String, :sql => ''VARCHAR2(32) NOT NULL'' property :body, String property :author, String property :create_time, Time property :hits, Fixnum, :sql_index => true has_many :comments, Comment end [/code] -- Posted via http://www.ruby-forum.com/.

...e didn''t like that name. I searched the internet and found a sample where the table name was plural (SESSIONS), so I made the change hoping for the best. Here is the SQL generated: CREATE TABLE "SESSIONS" ( "ID" NUMBER(38,0) NOT NULL ENABLE, "SESSION_ID" VARCHAR2(255) NOT NULL ENABLE, "DATA" CLOB, "CREATED_AT" DATE, "UPDATED_AT" DATE, PRIMARY KEY ("ID") ENABLE ) / CREATE INDEX "INDEX_SESSIONS_ON_SESSION_ID" ON "SESSIONS" ("SESSION_ID") / CREATE INDEX "INDEX_SESSIONS_ON_...

Deniz wrote: > Hi Everybody, > I am a newbie in this list so please forgive me if this is a lengthy > message. > Currently I am working on a project at my work place that includes > viewing some oracle tables(I do not have control over to rewrite the > tables) and searching the tables based on a given criteria with Rails. > Up untill now everything was working great. The

Hi, has anybody worked with oracle adt columns in the Rails ? I have a table with a column what has DER data type, described below: create or replace TYPE "DER" AS OBJECT (READABLE VARCHAR2(4000) ,DER BLOB ) obviously as a result I always have ''unsupported datatype'' error message. I''ve tried to add to oracle adapter and then to oci8 processing of this data type but ... in vain. Please, could you help me and explain how to add oracle user data type handlin...

...The problem seems to be the SQL being generated to lazy-load the columns metadata. "def columns(table_name, name = nil)" method generates the following SQL: select column_name, data_type, data_default, nullable, decode(data_type, ''NUMBER'', data_precision, ''VARCHAR2'', data_length, null) as length, decode(data_type, ''NUMBER'', data_scale, null) as scale from user_catalog cat, user_synonyms syn, all_tab_columns col where cat.table_name = ''#{NAME_OF_TABLE}'' and syn.synonym_name (+)= cat.table_name and col.table_na...

I am working with a legacy oracle database. The primary key is not defined as an integer but as a number. This results in a url with an id as a number, such as 1234.0 instead of 1234. It works fine, but I would prefer 1234 to be displayed in the url. I have attempted to redefine the model id method to convert to an integer using to_i method, but no luck. Any ideas? Thanks, Vaibhav -- Posted via