This week's book giveaway is in the OCAJP 8 forum.
We're giving away four copies of OCA Java SE 8 Programmer I Study Guide and have Edward Finegan & Robert Liguori on-line!
See this thread for details.
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 OCA Java SE 8 Programmer I Study Guide this week in the OCAJP 8 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: 1400
Can i write stored procedure inside another stored procedure ?
Scott Selikoff
author
Saloon Keeper

Joined: Oct 23, 2005
Posts: 3749
    
  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
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: stored procedure inside another stored procedure
 
It's not a secret anymore!