| Author |
Message |
    
Ferrari
Mudiripoyina Bewarse
Username: Ferrari
Post Number: 11583
Registered: 09-2010
Posted From: 132.189.76.43
Rating: N/A
Votes: 0 (Vote!) | | Posted on Tuesday, June 16, 2015 - 4:34 pm: |
|
Gochi:second way, oka table lo ee procedure names anni pettu...Execution Sequence, Proc Name, start time, end time, status...now from your procedure keep calling each of the entry from your table and update the start times,end times and status as they complete...
gos khan ee approach ki konchem pseudo code cheppavaa high level loo
Nandamuri Taraka Rama Rao - Sachin Ramesh Tendulkar
|
Gochi
Censor Bewarse
Username: Gochi
Post Number: 85805
Registered: 07-2004
Posted From: 8.7.228.252
Rating: N/A
Votes: 0 (Vote!) | | Posted on Tuesday, June 16, 2015 - 4:22 pm: |
|
Proofdada:sql server loo pl/sql copy paste thenk bhe fooxesh andhi... ooho idhi oracle ku vaduthara ani appudu thelisindhi...
 |
Proofdada
Bewarse Legend
Username: Proofdada
Post Number: 141351
Registered: 03-2004
Posted From: 38.96.203.34
Rating: N/A
Votes: 0 (Vote!) | | Posted on Tuesday, June 16, 2015 - 4:03 pm: |
|
pl/sql soottame kaani...eppudu raayala... sql server loo pl/sql copy paste thenk bhe fooxesh andhi... ooho idhi oracle ku vaduthara ani appudu thelisindhi... |
Gochi
Censor Bewarse
Username: Gochi
Post Number: 85803
Registered: 07-2004
Posted From: 8.7.228.252
Rating: N/A
Votes: 0 (Vote!) | | Posted on Tuesday, June 16, 2015 - 3:49 pm: |
|
Two approaches abbai...oka .bat file create chesi andulo oka daani tharavatha inkokati procedures anni call cheskuntaa po..like execute 1; execute 2 etc etc...ippudu aa batch file ni run chesthe anni oka daani tharavatha okati run aipothaayi...idhi crude method...
second way, oka table lo ee procedure names anni pettu...Execution Sequence, Proc Name, start time, end time, status...now from your procedure keep calling each of the entry from your table and update the start times,end times and status as they complete... |
Ferrari
Mudiripoyina Bewarse
Username: Ferrari
Post Number: 11582
Registered: 09-2010
Posted From: 132.189.76.43
Rating: N/A
Votes: 0 (Vote!) | | Posted on Tuesday, June 16, 2015 - 2:37 pm: |
|
Gochi:inkoka schema lo procedure execute cheyyaalante first nee ee schema ki grants ivvaali...grants isthe verey schema lo procedures kooda execute cheyyocchu..is it the issue with grants you are facing or are you looking for syntax of how to execute multiple procedures inside one procedure?
Grant can be given as below
grant execute on user1.proc to public; (Here user1 is the schema where the other procedures are present, User1 is your current schema)
gos khan..here are more details...grants are there..currently we are running the stored procs in schema A using informatica...sometimes we have to manually execute all the N workflows manually..for those situations we want to create a stored proc to run all the stored procs and update a process status table in the schema B
Nandamuri Taraka Rama Rao - Sachin Ramesh Tendulkar
|
Stewie
Kurra Bewarse
Username: Stewie
Post Number: 3061
Registered: 03-2011
Posted From: 66.151.13.191
Rating: N/A
Votes: 0 (Vote!) | | Posted on Tuesday, June 16, 2015 - 2:11 pm: |
|
EXECUTE IMMEDIATE use chesi gochi sir cheppinatlu .. pakka schemalo execute cheyyandi procs
A Famous Quote starts with a... and ends with this.
|
Onlymovies
Censor Bewarse
Username: Onlymovies
Post Number: 33037
Registered: 01-2009
Posted From: 199.173.224.30
Rating: N/A
Votes: 0 (Vote!) | | Posted on Tuesday, June 16, 2015 - 2:09 pm: |
|
Gochi:Grant
Sound Rakoodadee
|
Gochi
Censor Bewarse
Username: Gochi
Post Number: 85802
Registered: 07-2004
Posted From: 8.7.228.252
Rating: N/A
Votes: 0 (Vote!) | | Posted on Tuesday, June 16, 2015 - 2:05 pm: |
|
inkoka schema lo procedure execute cheyyaalante first nee ee schema ki grants ivvaali...grants isthe verey schema lo procedures kooda execute cheyyocchu..is it the issue with grants you are facing or are you looking for syntax of how to execute multiple procedures inside one procedure?
Grant can be given as below
grant execute on user1.proc to public; (Here user1 is the schema where the other procedures are present, User1 is your current schema) |
Ferrari
Mudiripoyina Bewarse
Username: Ferrari
Post Number: 11581
Registered: 09-2010
Posted From: 132.189.76.43
Rating: N/A
Votes: 0 (Vote!) | | Posted on Tuesday, June 16, 2015 - 1:53 pm: |
|
we have a package with N number of procedures in schema A. Now i need to create another stored proc in schema B which will execute all the procs in the package in schema A. elaa raali idi?
Nandamuri Taraka Rama Rao - Sachin Ramesh Tendulkar
|
Archives - 2015