Skip to main content
Question

Run oracle procedure via python shutdown script

  • August 1, 2013
  • 3 replies
  • 41 views

fmelizard
Safer
Forum|alt.badge.img+21
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
This post is closed to further activity.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.

3 replies

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