Made A small program, PB is used at the same time two Oracle database, the database connection string ready, under the users of A library, which can be repeatedly to the view of the B
Is there a problem but the Select

1 from the select field 1 into: variable view name @ connection B library do string where field=2: variable 2;

To take to the value of the tracking variables 2

1 the from the select field 1 into: variable view name @ connection B library do string where field 2='value of the variable 2;

Performed after the results and correct, can help solve the player didn't

CodePudding user response:

Select from time to tome what problem?

CodePudding user response:

Breakpoint tracking didn't give to the value of things that need to be into, can be the difference between the two sentences is behind the where only one field is a field==variable string, string or a breakpoint with variables to take to the value of Ctrl + C, available fields=: face is into not into value, semicolon, a colon all Angle half Angle difference, not just don't know what to ask

CodePudding user response:

Behind the SQL and check the sqlcode value code, if the SQL execution error, show the sqlca. The information in the sqlerrtext

CodePudding user response:

Test again today for a day, still not solved, also a Select in the same field values from the same view, some can take to, some will take less than, the difference is the where the back of the condition that=: variables, but behind the where used='string variable values can take to, take less than times sqlcode is ORA - 01462

CodePudding user response:

That is to say, when using the where=: variable, sometimes have to, sometimes take less than, it is no problem, select the grammar itself
But you said can't take record through the where=: 'string variable values can be achieved to again, this is very strange! Really can't understand,,,

This error message, it should be the insert will produce, select no reason?
ORA - 01462 always insert a string literals longer than 4000 characters

Cause: The longest literal supported by Oracle consists of 2000 characters.
Action: Reduce the number of characters in the literal to 2000 characters or fewer or use the VARCHAR2 or LONG datatype to insert strings exceeding 2000 characters.

You try the library B this view is directly linked to A library, which is in A library build A view of the same name, and then use this view to build A data window object, with the same name to the data window object to retrieve parameters test, so can reduce the code may lead to A problem,

CodePudding user response:

Should not code problem, wrote a measure directly
String a
A='string'
PB wrote
From the select field 1 into: variable view name @ link list where field=2: a
To continue the ORA - 01460
Write
From the select field 1 into: variable view name @ link list where field 2="string"
Results the normal
Two of the character set, a is one of 16 GBK AL32UTF8, this method in the code conversion or deal with

CodePudding user response:

So, baidu for a data
http://blog.csdn.net/lyn_bigdream/article/details/7473278
AL32UTF8 character set is 9 I didn't appear, so about 9 I visit without any problems later, but for 8 I and previous versions, do not know the character set, this makes the 8 I and a lower version of the client in order to access database of more than 9 I AL32UTF8 will encounter all sorts of problems,

That is to say, if your client is oracle 9 I previous version, just for more than 9 I version,
Pb of the character set is with the character set for the operating system, have nothing to do with oracle, so there is no way to on code,