ora-02005 error, long datatype/ConText and WebDB -Please Help

From: Joet Singh <jsingh_at_bigfoot.com>
Date: Tue, 10 Aug 1999 07:45:44 -0000
Message-ID: <ngVr3.3060$3X5.26277@insync>

I have a table with a long datatype column. I also have context running and am able to do searches as wanted through sql plus 8.0. Now the problem is when I go to webdb and create a "form on table/view" so that I can insert data in the long datatype, I am not able to insert more then ~2000 characters. Any idea why this is so when the long datatype can hold up to 4 GB in oracle 8.0. I get the following error when I place too much data(over~2000 characters) in the long datatype field:

ORA-02005 implicit (-1) length not valid for this bind or define datatype Cause: A negative length for the define variable was passed to a define function.
Action: An explicit, non-negative, length parameter must be passed.

2) when I query this table from webdb, I get full table in the report no matter what I search for. I have further tested this form by placing junk words in the query and the query spits out all rows within the table. anybody else experience this? Received on Tue Aug 10 1999 - 02:45:44 CDT