Topic: Transfer from java on plsql
The question here in what consists
Before requests immediately in java a type were written:
return jdbcTemplate.query ("select....
Now it is necessary to transfer all to a database in a type view (please, do not ask why anyhow - told, made)
Faced some problems. Such as:
At database transfer it is often necessary to do sampling by means of the filter. The problem dared by means of creation SET (PROCEDURE)/GET (FUNCTION)
But there are such problems when in the table immediately forms primary key and it was pulled out by request
where name (primary key) in (select column_value from table"
+ "(new tt_varchar2 (:name_whatineed))
How it is possible to process without a special damage it in view, with the filter on one of values in primary key?