SQL Developer

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Excel Import

user929252Dec 9 2009 — edited Dec 10 2009

Hi

We are trying to load an excel file using Sqldeveloper.
The message we are getting is this

SQL Error:ORA-12899: value too large for column "APPS"."ENTERED_PSO_DETAILS"."FORM_STATUS" (actual: 4, maximum: 3)

The field is VARCHAR2(3 BYTE)

Is there a way of stopping sqldeveloper from putting in the word NULL into that field.

Cheers

312396

Hi, Dominic. Your question of whether you should use Oracle Help for Java (OHJ) or Oracle Help for the Web (OHW) is answered by another question that you can hopefully answer yourself. If you want the help content to be installed on the client's machine, then you're best off using OHJ. If you'd like to host the help content on the server, then you ought to use OHW. The great thing about Oracle Help Technologies is that even if you commit to using one of our help systems, you can easily switch over to the other since we use the same help control files for both systems.

You can find out more about Oracle Help by reading the Oracle Help Guide at
http://otn.oracle.com/docs/tech/java/help/htdocs/ohguide/ohg_toc.html

You can deploy OHJ with any Java-based application, and OHW just needs a web browser.

To download OHJ and OHW (they are both free), go to
http://otn.oracle.com/software/tech/java/help/content.html

Hope this helps,
Ryan

1 - 1

Locked Post

New comments cannot be posted to this locked post.

Locked on Jan 7 2010

Added on Dec 9 2009

#excel, #import, #sql-developer

4 comments

914 views

SQL Developer

Excel Import

Comments

Post Details