ORA-01401: inserted value too large is return by oracle.
Usually what I do to see everything that is send and received between nd and oracle
is:-
1. In command center, for RDBS service, check all 3 check boxes for the debug level.
2. Get to the page where you have the problem.
3. Clear the log file using command center.
4. click your update button.
5. Look at the log. You will find one line that have the exact SQL that is sent from
ND to Oracle.
6. If you do not see any obvious problem in the SQL, you can export the log to a text
file by using the pull down menu log/export.
7. Load the text file and cut and paste the SQL and try to execute it using the oracle
worksheet manager (or sql*plus).
8. Usually you can manually modify that sql and find out what is wrong.
I am guessing that may be if the check box is unchecked you are sending a string of
"null" and that is too long.
"Ray" <[EMAIL PROTECTED]> wrote:
>
>I have a page with 3 checkboxes on it that are all bound to data fields in the page's
>data object. The CheckedValue property value is 'Y'. The UncheckedValue property
>value is null. When the page is initially loaded, the checkboxes are correctly
>checked
>or unchecked depending on their database values: 'Y' or null. The DDL for the
>(Oracle) database table column is VARCHAR2(1). My Update button's ActionType
>property value is BuiltIn. When I try to change the checkbox value and update, the
>change is not applied. The log file has the following error:
>
>ORA-01401: inserted value too large for column
>
>1. Why does Net Dynamics think the value I'm trying to insert is too large?
>2. How do I get visibility of the SQL (being an Update) so I can see exactly what the
> Data Service is generating?
_________________________________________________________________________
For help in using, subscribing, and unsubscribing to the discussion
forums, please go to: http://www.netdynamics.com/support/visitdevfor.html
For dire need help, email: [EMAIL PROTECTED]
