teiid not able to execute dml statements using native call.

kulbhushanc Jan 17, 2017 7:23 AM

Hi,

I am not able to execute ddl statements using "call oracleTestNative.native('delete from oracleTestNative.User.TableName;')".

where oracleTestNative is model name User is oracle user and TableName is name of table.

Thanks,

Kulbhushan Chaskar.

1. Re: teiid not able to execute dml statements using native call.

van.halbert Jan 17, 2017 7:46 AM (in response to kulbhushanc)

Kulbhushan,

Does hour VDB contain the translator override [1] to enable issuing native commands?

[1] SupportsDirectQueryProcedure - Translators - Teiid 8.13 - Project Documentation Editor

Van
Actions
2. Re: teiid not able to execute dml statements using native call.

kulbhushanc Jan 18, 2017 12:27 AM (in response to van.halbert)

I don't have permission to access the page ([1] SupportsDirectQueryProcedure - Translators - Teiid 8.13 - Project Documentation Editor) you mentioned in reply
Actions
3. Re: teiid not able to execute dml statements using native call.

rareddy Jan 18, 2017 9:49 AM (in response to kulbhushanc)

It is not a protected page. It may ask you to login, but same user/password to create this post is required for that too.

Nevertheless, you need to create a translator override with above property and then use that translator in your model. See the UI tab on "vdb explorer" window for translator overrides and turn the property "SupportsDirectQueryProcedure" to true.
Actions