Run the sql for pdb database

[sdpdb]

Hi @biemond

Do we have any module ( like ora_exec) which can help us to run the sql against the pdb database,
I can see it is there in puppet enterprise , looking for some other alternate,

Thanks,

[biemond]

Hey, oh I guess it is possible but we need to check the current state to see if this sql is already executed. insert is probably easy with a pk check , update is harder. Or some ddl stuff.

what are you thinking of ?

[sdpdb]

Understood, that I can check- sql status mean it executed or not ..
I am looking for- which is the best way to achieve sql execution on PDB ( pluggable database ).

puppet enterprise version supporting it ,but I am looking for some other alternate.

Thanks

[sdpdb]

Hi @biemond

Any idea , how can I achieve my requirement.
Do we have any module or other way I can execute the sql directly on PDB ( pluggable database )..

Thanks