Radicore Forum
Fast Uncompromising Discussions. FUDforum will get your users talking.

Home » RADICORE » How To » LIST2 Pattern Problem
Re: LINK2 Pattern Problem [message #2137 is a reply to message #2120] Thu, 18 June 2009 12:02 Go to previous messageGo to previous message
ajwid01 is currently offline  ajwid01
Messages: 26
Registered: June 2009
Location: UK
Junior Member
Tony,

I'm going to wait until tomorrow, when I can implement the changed code you have sent through to the installation, and just double-check that nothing I have done (and failed to UNDO properly) in the code is causing issues.

I just started to look at a fresh install, and came across an anomaly on the MNU_TASK_FIELD table inserts.

Table is defined as:

Name                       Null?    Type
 ------------------------- -------- ----------------------------
 TASK_ID                   NOT NULL VARCHAR2(80 CHAR)
 FIELD_ID                  NOT NULL VARCHAR2(40 CHAR)
 CREATED_DATE              NOT NULL TIMESTAMP(6)
 CREATED_USER              NOT NULL VARCHAR2(16 CHAR)
 FIELD_DESC                         VARCHAR2(255 CHAR)
 REVISED_DATE                       TIMESTAMP(6)
 REVISED_USER                       VARCHAR2(16 CHAR)


Inserts are attempted like:

INSERT INTO mnu_task_field VALUES('mnu_control(upd3)', 'DEFAULT_LANGUAGE', NULL, '2006-04-10 09:36:18', 'AJM', '2007-09-10 10:44:37', 'AJM')
                                                                                 *
ERROR at line 1:
ORA-12899: value too large for column "MENU"."MNU_TASK_FIELD"."CREATED_USER"
(actual: 19, maximum: 16)



So, looks like a field is being inserted 'out of order' with that expected by the table in this instance.

I spooled everything out to logfiles from SqlPlus initially, but obviously missed the odd error.

So, as per the above, I'll continue tomorrow with a fresh install from your newly-worked Oracle code elements, double-check that there aren't some other errors creeping in along the way, and then at least I'll be debugging from a "clean" install position.

Hopefully I'll end up with a good ending to the week, come close of play tomorrow.

Failing that, I'll have time to mull some things over whilst traipsing down to Heathrow and back tomorrow evening.

Shocked

T.

[Updated on: Thu, 18 June 2009 12:03]

Report message to a moderator

 
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Previous Topic: Question about the session page stack
Next Topic: AUTO_INCREMENT PK Column for Oracle Table
Goto Forum:
  


Current Time: Wed Nov 27 17:55:05 EST 2024

Total time taken to generate the page: 0.01520 seconds