Ferrari
Mudiripoyina Bewarse Username: Ferrari
Post Number: 11582 Registered: 09-2010 Posted From: 132.189.76.43
Rating: N/A Votes: 0 | 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
|