Skip to main content
Question

Run oracle procedure via python shutdown script


fmelizard
Safer
Forum|alt.badge.img+19
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

fmelizard
Safer
Forum|alt.badge.img+19
  • Author
  • Safer
  • August 2, 2013
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.

david_r
Celebrity
  • August 2, 2013
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

fmelizard
Safer
Forum|alt.badge.img+19
  • Author
  • Safer
  • August 2, 2013
Hi David,

 

 

I ahd a look at it before, thanks anyway.

 

 

Yes the start\\end SQL is my solution.

 

 

Have a nice weekend.

Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings