I have several jobs doing this. Syntax is something like:
<procedure id="insertStaff" parameterClass="java.util.Map">
{ call BB.USERS_PKG.ADD_USER(
p_usernumber =>#uid#,
p_username => #username#,
p_email => #mail#,
p_user_type => 'STAFF',
p_first_names => #givenName#,
p_preferred_name => #preferredName#,
p_last_name => #sn#) }
</procedure>
cheers
On 24/03/15 18:56, Clément OUDOT wrote:
2015-03-23 12:47 GMT+01:00 Hettler, Jakub <[email protected]>:
Hi all,
please, is there a way how to call stored procedures in Oracle as insert,
update, delete operation?
Seems this is possible with iBatis:
https://ibatis.apache.org/docs/dotnet/datamapper/ch03s03.html
So you can try to use stored procedures in the XML iBatis file (locate
in sql-map-config.d/)
If it does not work, try the Executable plugin
(http://lsc-project.org/wiki/documentation/plugins/executable) and
code the call to stored procedures in scripts
Clément.
_______________________________________________________________
Ldap Synchronization Connector (LSC) - http://lsc-project.org
lsc-users mailing list
[email protected]
http://lists.lsc-project.org/listinfo/lsc-users
--
Dr Robin Garner
Technology Services
Southern Cross University
P: +61 2 6620 3281 M: +61 418 619 500
http://cs.anu.edu.au/people/robin.garner/
_______________________________________________________________
Ldap Synchronization Connector (LSC) - http://lsc-project.org
lsc-users mailing list
[email protected]
http://lists.lsc-project.org/listinfo/lsc-users
