Oracle SAP driver does not read cursors?

[Former Member]

Hi guys,

I have a db connection pool to an Oracle database and I want to use the standard SAP driver provided. From application side I cannot manage to read a cursor from a stored procedure on the Oracle db side. With thin driver from Oracle is working.

Could you please provide a short example if you are using this environment?

In the end I want to achieve a resultset from a stored procedure, using SAP driver. If you have other solutions to achieve this please post them here.

Thanks,

Catalin

[Former Member]

Hi Catalin,

any reasons against importing and using the original Oracle driver in EP6?

Victor

[Former Member]

In the Visual Administrator, if you go to the JDBC Connector Service and look at the standard SAP driver, you will notice that the SQL engine option is set to Open SQL. This is probably the reason why you cannot use cursors. The best solution would be to create your own JDBC connection, even if it is to the same database, and check the Vendor SQL option. This would also mean you would have to load the Oracle drive under the Drivers section.

Ray

P.S. If helpful, please award points.

[Former Member]

Hi Ray,

I am not using NW, but EP6, for which Visual Composer does not allow customizing this property.

Anyway, we manage to do it using temporary tables, but which is more expensive.

Catalin