|
SoftTree Technologies
Technical Support Forums
|
|
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: 7854
|
|
|
|
Sure
|
|
DatabaseConnect ... or DatabaseConnectEx ...
DatabaseExecute "CALL my_proc(parameters)", rows_affected
DatabaseDisconnect |
or
|
|
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 |
|
|
|
|
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
|
|
|