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 |
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.
T.
[Updated on: Thu, 18 June 2009 12:03] Report message to a moderator
|
|
|
|
|
LIST2 Pattern Problem
By: ajwid01 on Thu, 18 June 2009 04:52
|
|
|
Re: LINK2 Pattern Problem
By: AJM on Thu, 18 June 2009 05:25
|
|
|
Re: LINK2 Pattern Problem
By: ajwid01 on Thu, 18 June 2009 05:58
|
|
|
Re: LINK2 Pattern Problem
By: AJM on Thu, 18 June 2009 06:17
|
|
|
Re: LINK2 Pattern Problem
By: ajwid01 on Thu, 18 June 2009 06:24
|
|
|
Re: LINK2 Pattern Problem
By: ajwid01 on Thu, 18 June 2009 07:19
|
|
|
Re: LINK2 Pattern Problem
By: AJM on Thu, 18 June 2009 09:36
|
|
|
Re: LINK2 Pattern Problem
By: ajwid01 on Thu, 18 June 2009 09:40
|
|
|
Re: LINK2 Pattern Problem
By: AJM on Thu, 18 June 2009 10:10
|
|
|
Re: LINK2 Pattern Problem
By: AJM on Mon, 22 June 2009 11:19
|
|
|
Re: LINK2 Pattern Problem
By: ajwid01 on Thu, 18 June 2009 09:52
|
|
|
Re: LINK2 Pattern Problem
By: AJM on Thu, 18 June 2009 10:19
|
|
|
Re: LINK2 Pattern Problem
By: ajwid01 on Thu, 18 June 2009 09:54
|
|
|
Re: LINK2 Pattern Problem
By: ajwid01 on Thu, 18 June 2009 10:30
|
|
|
Re: LINK2 Pattern Problem
By: ajwid01 on Thu, 18 June 2009 10:36
|
|
|
Re: LINK2 Pattern Problem
By: AJM on Thu, 18 June 2009 10:47
|
|
|
Re: LINK2 Pattern Problem
By: ajwid01 on Thu, 18 June 2009 11:01
|
|
|
Re: LINK2 Pattern Problem
By: AJM on Thu, 18 June 2009 11:44
|
|
|
Re: LINK2 Pattern Problem
By: ajwid01 on Thu, 18 June 2009 12:02
|
|
|
Re: LINK2 Pattern Problem
By: AJM on Thu, 18 June 2009 12:52
|
|
|
Re: LINK2 Pattern Problem
By: ajwid01 on Fri, 19 June 2009 08:40
|
|
|
Re: LIST2 Pattern Problem
By: AJM on Fri, 19 June 2009 09:11
|
|
|
Re: LIST2 Pattern Problem
By: ajwid01 on Fri, 19 June 2009 09:58
|
|
|
Re: LIST2 Pattern Problem
By: AJM on Fri, 19 June 2009 10:55
|
|
|
Re: LIST2 Pattern Problem
By: ajwid01 on Mon, 22 June 2009 09:30
|
|
|
Re: LIST2 Pattern Problem
By: AJM on Mon, 22 June 2009 09:51
|
|
|
Re: LIST2 Pattern Problem
By: ajwid01 on Mon, 22 June 2009 11:10
|
|
|
Re: LIST2 Pattern Problem
By: ajwid01 on Mon, 22 June 2009 11:35
|
|
|
Re: LIST2 Pattern Problem
By: ajwid01 on Mon, 22 June 2009 11:38
|
|
|
Re: LIST2 Pattern Problem
By: AJM on Mon, 22 June 2009 11:48
|
Goto Forum:
Current Time: Wed Nov 27 17:55:05 EST 2024
Total time taken to generate the page: 0.01520 seconds
|