Radicore Forum: How To » LIST2 Pattern Problem

Home » RADICORE » How To » LIST2 Pattern Problem

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

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.

Shocked

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

Report message to a moderator

[Message index]

		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

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

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

] [

]

Current Time: Sat Aug 17 05:59:51 EDT 2024

Total time taken to generate the page: 0.01841 seconds