k2v-academy / K2View-Academy

Other
0 stars 0 forks source link

Which fabric actor to use to run the below query EXEC DBMS_STATS.GATHER_TABLE_STATS(OWNNAME => 'schemaname',TABNAME=> 'tablename',ESTIMATE_PERCENT => DBMS_STATS.AUTO_SAMPLE_SIZE,CASCADE=>TRUE,DEGREE=>16); It is a store procedure call #977

Closed Dhf85QhZmxBfzbRoSr29MwUhCE9m7npTpcLLYdE closed 9 months ago

i7QC2njzxHCc0LYBqCh0HQf30xF2DYuJjqtFbNe commented 9 months ago

Hi,

You should create LuFunction actor that will call Java function that uses this store procedure.

You can't use DbCommand for this purpose.

F78aPg0zjWnRKWkYrBd6lShvmAYl8doniMtEnFN commented 9 months ago

See #747 for some code snippets.