JNDI + PARAMETERS

[jflelouarne]

Hello, 

I'm trying to use JNDI connection to an Oracle database.

The connection esthablishes well, and the queries, when there is no parameters, work also well.

The issue is when there is a parameter .. then I wonder what happen, but it does not give back the result I'm waiting for.

Is there any known issue or special trick with jndi and bind variables ?

Thanks.

[jflelouarne]

An dperhaps it's an issue only or specifically in input conrols ...

[Friendly User]

The query execution of the input control queries and report queries should not be any different for JDBC and JNDI connection. JNDI is a connection pool of similar database connections that are managed by the application server. It cannot be parameterized because they are pre-defined in the context.

But in queries there should be no difference. The query like "select myField from myTable where myField=$P{someParam}" will be executed the same against JDBC and JNDI data source that point to the same database and schema.

[jflelouarne]

What I notice is that, if I have a PL/SQL package named 'MyPackage' and, inside this package, a function named 'MyFunc', the following query works well with JDBC connector, but failed with JNDI :

select MyPackage.MyFunc(whatNeedToBeHere) as test from dual