Topics Topics Help/Instructions Help Edit Profile Profile Member List Register Paatha Gnyapakaalu - Archives from Old DB  
Search New Posts 1 | 2 | 8 Hours Search New Posts 1 | 3 | 7 Days Search Search Tree View Tree View Latest tweets Live Tweets   Hide Images

Rate this post by selecting a number. 1 is the worst and 5 is the best.

    (Worst)    1    2    3    4    5     (Best)

Author Message
Top of pagePrevious messageNext messageBottom of page Link to this message

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

Topics | Last Hour | Last Day | Last Week | Tree View | Search | Help/Instructions | Program Credits Administration