Question

Run oracle procedure via python shutdown script

  • 1 August 2013
  • 3 replies
  • 3 views

Userlevel 4
Badge +13
Hallo all,

 

 

I need to make sure that my procedures (enabling triggers and constrints) are run at the end of my translation.

 

Since I have no idea if any of my writers will be triggerd I cannot use the end sql.

 

After googling I came across the following module (cx_Oracle), but I dont know how to use it with procedures, or if it is at all possible.

 

Any assistance would be helpful.

 

 

Itay

3 replies

Userlevel 4
Badge +13
well, I have decided that te end sql is useful, since each writer can be connected to a start and end sql. this way the procedure is run before and after database interaction.
Userlevel 4
Hi Itay,

 

 

does this mean that you found a solution?

 

 

In any way, here is the documentation for the cx_oracle module:

 

http://cx-oracle.sourceforge.net/html/index.html

 

 

David
Userlevel 4
Badge +13
Hi David,

 

 

I ahd a look at it before, thanks anyway.

 

 

Yes the start\\end SQL is my solution.

 

 

Have a nice weekend.

Reply