How to export SQL package in SQL statement file ?

Dear,

we are analyzing a webMethods implementation which contain package for the SQL , to ease our analysis, we would like from the developer “export” the package in a readable SQL statement format.

How is this feasible ?

thanks,
Luc

Hi Luc,

which Version of wM are you using?

Can you explain the package structure (esp. where the SQL resides)?

Is it using JDBC-Adapter or WmDB?

Which Database (type and version) are you connecting to?

Regards,
Holger

Luc – Give more details of the implementation. So that we can share our views.

Thanks,

Hi Holger,

they are using WM 8.2 , JDBC Adapter to Oracle 11

Regards, Luc

Hi Luc,

plesase check if you are on the correct DB driver.
These are available from Oracle TechNet (OTN).
Its version should be the latest 11 or 12 version.

Dependent on the JVM you are using it is called ojdbc5.jar or ojdbc6.jar.

Hi,

let me reformulate my question :

we are analyzing a webMethods implementation which has several packages with sql to Oracle databases via JDBC adapter .

We would like to export all these out of webMethods in a readable SQL statement format (.txt files,…)

How is this feasible ?

thanks,
Luc