• Post Reply Bookmark Topic Watch Topic
  • New Topic

stored procedure inside another stored procedure  RSS feed

 
kri shan
Ranch Hand
Posts: 1489
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Can i write stored procedure inside another stored procedure ?
 
Scott Selikoff
author
Bartender
Posts: 4085
21
Eclipse IDE Flex Google Web Toolkit
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
You can write a stored procedure that creates or uses other stored procedures but keep in mind stored procedures are genereally not temporary objects (as in they are created/dropped for the span of another stored procedure) although there's nothing to stop you from doing so.
 
Paul Sturrock
Bartender
Posts: 10336
Eclipse IDE Hibernate Java
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Not an ORM question. Of this goes to JDBC.
 
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!