Installed in delphi7 odac93 version of the component, the oracle database query access; But at the time of the query, if parameterized queries, encountered a problem:

If oracle BBB repository has a table, the table there is a field, a field of a type is char [20]. Pay attention to not varchar, but char;
And do have a table inside field a=9999 record, that is to say, I am in PLSQL develop to execute the select * from BBB where a='9999', when there are returns a record;

But I want to have 9999 parameterize input;

Placed a TOraQuery component on the window, and then set the SQL. The text is:

 
Select * from BBB where a=: param1 

And then set Toraquery paramByName [' param1] :='9999';
Then Toraquery. Open, and the results returned to the zero records;

Very strange;
Why would it look like?

If the field is a type of varchar, can return records correctly;

CodePudding user response:

Can use OraTracer with background, see the specific situation,