long datatype -context/webdb -Please help
From: Chad Naeger <chad_at_naeger.com>
Date: Sun, 8 Aug 1999 00:53:41 -0500
Message-ID: <j%8r3.2449$3X5.20334_at_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:
Date: Sun, 8 Aug 1999 00:53:41 -0500
Message-ID: <j%8r3.2449$3X5.20334_at_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 experiencing this?
any help is appreciated as I am at my wits end as to what to do at this point. Received on Sun Aug 08 1999 - 07:53:41 CEST