Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations wOOdy-Soft on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
need : syntax for stored procedure inside of stored procedure.
- Thread starter bjgrem
- Start date
Looks like this is a SqlServer question (from the names of the stored procedures.
In Oracle you can do something like this in two ways (might give you an idea):
1) Create a stored procedure as a user which has the permissions to do what you need and call these sp's from inside your stored proc.
2) Create a 'package' which is a way of bundling data and procedures together.
In Oracle you can do something like this in two ways (might give you an idea):
1) Create a stored procedure as a user which has the permissions to do what you need and call these sp's from inside your stored proc.
2) Create a 'package' which is a way of bundling data and procedures together.
- Status
Similar threads
- Locked
- Question
- Locked
- Question