aspose file tools
The moose likes JDBC and Relational Databases and the fly likes stored procedure inside another stored procedure Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of RabbitMQ in Depth this week in the Open Source forum!
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
Bookmark "stored procedure inside another stored procedure" Watch "stored procedure inside another stored procedure" New topic
Author

stored procedure inside another stored procedure

kri shan
Ranch Hand

Joined: Apr 08, 2004
Posts: 1389
Can i write stored procedure inside another stored procedure ?
Scott Selikoff
author
Saloon Keeper

Joined: Oct 23, 2005
Posts: 3740
    
  10

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.


[OCA 8 Book] [Blog]
Paul Sturrock
Bartender

Joined: Apr 14, 2004
Posts: 10336

Not an ORM question. Of this goes to JDBC.


JavaRanch FAQ HowToAskQuestionsOnJavaRanch
 
jQuery in Action, 2nd edition
 
subject: stored procedure inside another stored procedure