Re: TNS-12571 when editing text boxes in developer 6i with Oracle 9.2

Carlos wrote:

> Thank you Frank but... just tell me something that I didn't already
> know!! ;-)
>
> Looked up the Oracle error messages and the metalink references (and I
> have seen your quote too). But my note was meant to try and find
> someone who has experienced this before. Nobody seems to have faced
> this problem. Maybe we are some kind of 'oracle software explorers'
> stepping territories not stepped before?
>
> BTW. If we try to insert some new rows from the developer window and
> we hit the 'save' button, it displays 'working...' with no results.
> Tracing the session, it appears to execute a single INSERT statement
> with bind variables (some kind of INSERT into TABLE (row1, row2...)
> values (:value1, :value2...) and it just hangs.
>
> Note that it must be related with some window activity, since ALL SQL
> statements written inside Forms triggers work OK!!
>
> There would be so much to talk about the Oracle politics of forcing
> its customers' architectures: 'Move from C/S to three tier with our
> OAS'. 'We will not support C/S architectures anymore'.
>
> BTW. Patch 15(!!) neither seems to fix this problem... Maybe in patch
> 16... or 17. Oracle looks more and more like Microsoft, though
> Microsoft releases the patches for free, no 'metalink' required.
>
> Kind regards.
>
> Carlos.
>
> Frank <fbortel_at_nescape.net> wrote in message news:<bqssap$v5o$1_at_news4.tilbu1.nb.home.nl>...
>

>>Carlos wrote:
>>
>>
>>>Oracle DB Version: 9.2.0.1
>>>DB character set : UTF8 (not AL32UTF8)
>>>Client: Oracle Forms 6i Patch 14 in Client/Server mode.
>>>Client NLS_LANG: AMERICAN_AMERICA.UTF8.
>>>
>>>Going through a nightmare since we moved from Oracle 8.1.7 with Forms
>>>6.0 to Oracle 9.2 with Forms 6i!!
>>>
>>>After much work (nls_lang, unicode fonts...), we can see UTF8 tables
>>>in Forms with their UTF8 characters OK, but when we try to EDIT one
>>>single textbox, just in the moment we strike a key (no matter if it is
>>>DEL, or another one) TNS-12571 appears!!
>>>
>>>If we issue a single update command in, for example,
>>>WHEN_NEW_FORM_INSTANCE trigger (UPDATE TABLE_A SET
>>>COLUMN_A='Blah,blah, blah...' WHERE Blah, blah, blah) the update works
>>>OK and the data is updated in the DB.
>>>
>>>Searched metalink with no results.
>>>
>>>Any ideas?
>>>
>>>Thanks in advance.
>>
>>No bother looking up the error for you :-v
>>12571, 00000, "TNS:packet writer failure"
>>// *Cause: An error occurred during a data send.
>>// *Action: Not normally visible to the user. For further details, turn
>>// on tracing and reexecute the operation. If error persists, contact
>>// Oracle Customer Support.

Ok, so you searched Metalink with results - at least the error became clear. And that was not clear in your post.

What client do you use? Perhaps the 9i client (more specific the network layer) will resolve the error condition. Character mapping is done in the network layer.

Just a wild guess, tho

-- 
Regards, Frank van Bortel