search

biemond / biemond-oradb

Puppet Oracle Database Module
Apache License 2.0
59 stars 113 forks source link

Run the sql for pdb database #287

Open sdpdb opened 3 years ago

sdpdb commented 3 years ago

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 commented 3 years ago

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 commented 3 years ago

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 commented 3 years ago

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