Displaying 3 results from an estimated 3 matches for "empty_clob".
2007 Sep 27
2
text_area empty_clob()
Anyone know why my text_area field is being prefilled with
"empty_clob()" instead of simply being empty like I would
expect? I''m using Oracle 10g so I suspect it''s coming from
the oci8 driver somehow?
Here''s the code:
<% form_for :user do |f| -%>
<%= f.text_area :notes, :rows => 2, :cols => 32 %>
<% end -%>
I...
2007 Oct 05
11
Session handling busted on Oracle
...''m forbidden, so here
you go.
The first problem is that the sql to create the sessions table is
broken. This is what it tried to send:
CREATE TABLE sessions (
id NUMBER(38) NOT NULL PRIMARY KEY (38), --> Problem here
hashid VARCHAR2(32),
created_at DATE,
ivars CLOB DEFAULT empty_clob()
)
The problem is that second "(38)" after "PRIMARY KEY". So, I removed
that and created the table manually.
The next problem was a missing Oracle sequence (which I had no idea was
required, but ok). I figured out (by stepping through oci8.rb) that the
name of the sequence sh...
2007 Oct 08
0
Camping-list Digest, Vol 18, Issue 1
...> The first problem is that the sql to create the sessions table is
> broken. This is what it tried to send:
>
> CREATE TABLE sessions (
> id NUMBER(38) NOT NULL PRIMARY KEY (38), --> Problem here
> hashid VARCHAR2(32),
> created_at DATE,
> ivars CLOB DEFAULT empty_clob()
> )
>
> The problem is that second "(38)" after "PRIMARY KEY". So, I removed
> that and created the table manually.
>
> The next problem was a missing Oracle sequence (which I had no idea
> was
> required, but ok). I figured out (by stepping through o...