Re: FORMS 3.0 : Truncated Error Message

ALAN -- Support couldn't tell you how to scroll the error since

        Forms 3.0 doesn't provide a way to do it. For Forms 4.0 we've
        made the Display Error screen contain two scrolling regions
        so you can investigate the errors and offending statements
        respectively to their full textual detail.

        A technique I use for debugging these situations is to 
        turn on an undocumented, unsupported SQL*Net debugging
        flag to trace the contents of packets going and coming 
        across the network. 

        This is not guaranteed to work, and please don't call in to
        Worldwide Support if it doesn't, but what I do is:

          % sh


          $ OSNTDBUG=0x200

          $ export OSNTDBUG


          $ iap30 deptform scott/tiger_at_t:hostname:SIDNAME 2>net.trace



        Then, upon exiting you can look in 'net.trace' (which received
        the output of stderr while you were running) and among other
        things, see that INSERT statement sent by the client:

	osntra send 82 bytes:
	00 4E 01 00 03 03 0C 00  |.N......|
	00 00 05 00 29 71 C4 00  |....)q..|
	00 00 3F 49 4E 53 45 52  |..?INSER|
	54 20 49 4E 54 4F 20 44  |T INTO D|
	45 50 54 28 44 45 50 54  |EPT(DEPT|
	4E 4F 2C 44 4E 41 4D 45  |NO,DNAME|
	2C 4C 4F 43 29 20 56 41  |,LOC) VA|
	4C 55 45 53 20 28 3A 44  |LUES (:D|
	45 50 54 4E 4F 2C 3A 44  |EPTNO,:D|
	4E 41 4D 45 2C 3A 4C 4F  |NAME,:LO|
	43 29 00 00 00 00 00 00  |C)......|

        And the response from the server that was received:

	osntra recv 126 bytes:
	00 7A 01 00 04 00 00 00  |.z......|
	00 05 78 00 00 05 78 00  |..x...x.|
	05 00 01 02 00 00 00 00  |........|
	00 00 00 00 00 00 00 00  |........|
	00 00 00 00 00 00 00 00  |........|
	00 00 00 00 00 00 0D 00  |........|
	00 00 00 00 00 48 4F 52  |.....HOR|
	41 2D 30 31 34 30 30 3A  |A-01400:|   <=== There's your error!
	20 6D 61 6E 64 61 74 6F  | mandato|
	72 79 20 28 4E 4F 54 20  |ry (NOT |
	4E 55 4C 4C 29 20 63 6F  |NULL) co|
	6C 75 6D 6E 20 69 73 20  |lumn is |
	6D 69 73 73 69 6E 67 20  |missing |
	6F 72 20 4E 55 4C 4C 20  |or NULL |
	64 75 72 69 6E 67 20 69  |during i|
	6E 73 65 72 74 0A 00 00  |nsert...|

        I switch to the Bourne shell, since it can redirect standard
        error independently of stdout, which I haven't found a way to
        do in C shell yet.

        Hope this little (unsupported) tidbit helps you and others
        help themselves until you get Forms 4.0 down the road.

--

Steve Muench         Email: smuench_at_oracle.com
Forms Development      CIS: 73404,676
Product Manager
Oracle Corporation