truly odd problem
Date: Wed, 11 Aug 1999 08:10:14 -0000
Message-ID: <pJes3.3682$3X5.28573_at_insync>
[Quoted] I had been trying to deploy a internal web site using oracle 8.1 and webdb2.0 and intermedia(context), for our client. One of the tables contains a Long datatype (CLOB). When I would test this table and context [Quoted] from SQL*PLUS by trying to insert, update and query the long datatype table [Quoted] I had no problems. When I would try to do same using webdb I ran into several problems:
[Quoted] 1) I could not insert more then 2000 characters in the long datatype, if I [Quoted] try to insert over 2000 characters I would get:
ORA-02005 implicit (-1) length not valid for this bind or define datatype
[Quoted] Cause: A negative length for the define variable was passed to a define
function.
[Quoted] Action: An explicit, non-negative, length parameter must be passed.
2) When I would query the long datatype via webdb it will spit out all rows [Quoted] within the table regardless of the words used(does not matter if words are [Quoted] in the field or not) for query.
Now the odd part, since I was not getting anyplace with solving this problem [Quoted] I set up oracle 8.0 and webdb2.0 on my personal computer, as almost all the [Quoted] books I have are on oracle 8.0. I was hoping I maybe be able to go and [Quoted] atleast read up on this problem. Now, I have established the same tables in [Quoted] oracle 8.0 and have started up context and can get the results I want using [Quoted] SQL*PLUS when I query, insert, update. But I am still having problems with [Quoted] webdb but I am *getting different errors*. 3)When I go to insert data, I [Quoted] still can not insert more then 2000 characters in the long datatype field, [Quoted] if I try to insert more then 2000 characters I get following error now:
[Quoted] ORA-06502: PL/SQL: numeric or value error ORA-06512: at "WEBDB.WWV_ARRAY_UTIL", line 134 ORA-06512: at "JSINGH.INSERT_RESUME_FORM", line 234 ORA-06512: at line 1
4) When I query this column via webdb, as before I am getting all rows [Quoted] returned regardless of query words.
Anybody have ideas what I should look at, the above errors descriptions are [Quoted] not truly helpful when I went and looked them up? ANY and ALL help is truly appreciated :-) Received on Wed Aug 11 1999 - 10:10:14 CEST