Guys im trying to call a stored procedure but although im preaty sure the name is correct, and i have tryied it with schema prefix , it says its not declared. Could it be that my user doesnt actualy have access to the procedure? Also: "select * from user_objects where object_type = 'PROCEDURES';" doesnt have a single result.
How can i check if my user can execute the procedure? I dont have admin priveliges
This is the result of searching for my procedure: http://pastie.org/874023
how would you call this procedure?