1

Topic: insert into manually and through application

Good afternoon.
Recently there was a problem of following character
Start insert a type
insert into TAB_NAME (Col1, Col2, COl3)
select... from...
In select packets are used.
Manually and through application produces different results.
At start manually Col3 (type NUMBER) is filled completely, as well as it is necessary.
At start through application Col3 on it is in overwhelming majority filled NULL
From outside  insert' are produced with identical sql_id, plan_hash_value
On the fresh test of such problem it is not watched.

2

Re: insert into manually and through application

alex722;
an error , and in the manual can appears null
If in   f-tsii the result can be mismatched
.....
stax

3

Re: insert into manually and through application

Stax;
Too much it is made test starts to expostulate on a floating error.

4

Re: insert into manually and through application

5

Re: insert into manually and through application

alex722 wrote:

insert into TAB_NAME (Col1, Col2, COl3)
select... from...
In select packets are used.

AUTHID?
Context?
The circuit, synonyms?
...
Underground knock.

6

Re: insert into manually and through application

alex722, and  can show?

7

Re: insert into manually and through application

Correct setting NLS_TERRITORY for session on the application server helped.

8

Re: insert into manually and through application

alex722 wrote:

correct setting NLS_TERRITORY for session on the application server Helped.

Means .