SoftTree Technologies Technical Support Forums Register • Search • FAQ • Memberlist • Usergroups • Log in Stored Procedure from JAL Script      SoftTree Technologies Forum Index » 24x7 Scheduler, Event Server, Automation Suite View previous topic View next topic Stored Procedure from JAL Script Author Message jeff33190 Joined: 22 Aug 2007 Posts: 96 Stored Procedure from JAL Script Can I call an Oracle procedure from JAL script or is it necessary to create a "SQL" job script? Thanks, Jeff Tue Dec 18, 2007 10:47 am SysOp Site Admin Joined: 26 Nov 2006 Posts: 7847 Sure Code: DatabaseConnect ... or DatabaseConnectEx ... DatabaseExecute "CALL my_proc(parameters)", rows_affected DatabaseDisconnect or Code: DatabaseConnect ... or DatabaseConnectEx ... DatabaseExecute "BEGIN  any PL/SQL_code here; END;", rows_affected DatabaseDisconnect Tue Dec 18, 2007 11:20 am jeff33190 Joined: 22 Aug 2007 Posts: 96 Thanks! Tue Dec 18, 2007 11:25 am Display posts from previous:  All Posts1 Day7 Days2 Weeks1 Month3 Months6 Months1 Year  Oldest FirstNewest First     SoftTree Technologies Forum Index » 24x7 Scheduler, Event Server, Automation Suite All times are GMT - 4 Hours Page 1 of 1   Jump to:  Select a forum ----------------SQL AssistantDB Audit, DB Mail, DB Tools24x7 Scheduler, Event Server, Automation SuiteTips & Snippets Repository You cannot post new topics in this forum You cannot reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum     Powered by phpBB © 2001, 2005 phpBB Group Design by Freestyle XL / Flowers Online.