Oracle Packages - Are they supported?

[werx.io]

Hello,

I am using TEIID Runtime 8.7.1 within Eclipse / JBoss plugin. When I create a VDB from an Oracle JDBC datasource, packaged procedures lose their package prefix and I am unable to call them.

I have tried editing the Name in Source, adding the prefix (CIS_UTILS) both in separate quotes and without as it is above, but I have been unable to call the procedure. 

Are packaged procedures supported?

Thank you,

Hank Ratzesberger

TechFlow, Inc.

[shawkins]

> Are packaged procedures supported?

Better support is being addressed by [TEIID-3870] Add ability to properly qualify package objects - JBoss Issue Tracker and [TEIIDDES-2751] Add ability to import Oracle Packages via JDBC Import - JBoss Issue Tracker

But those issues have not been back ported to older DV releases yet.

> I have tried editing the Name in Source, adding the prefix (CIS_UTILS) both in separate quotes and without as it is above, but I have been unable to call the procedure.

The name in source needs a separate part for the package name - "schema"."package"."object"

[werx.io]

Thanks Steven. Look forward to that. --Hank