Hello everyone!

I'm working with a client that wants to use a JDBC driver to call a
stored procedure for provisioning. Basically the driver is neither being
used in direct or indirect mode rather schema unaware mode and calling
the stored procedure "updateUser" to work all the background user

The stored procedure is inside a package so the full name of the sp is
in the schema.package.procedure-name format. I'm using the
jdbc:call-procedure node for the call. If i call it that way i get an
error stating "Unable to retrieve metadata for procedure/function
'SIRA_USER.MM_USER_MGR.UPDATEUSER'. Please check the procedure/function
name again and add a schema qualifier if necessary. The absence of this
metadata may affect this driver's ability to call this stored
procedure/function correctly."

After some reading i found out that if the sp is called with a full name
in the schema.procedure-name format, that is if the procedure is not
inside a package, the driver has no problems retrieving. As a workaround
i made an sp that calls the sp inside the package.

I wanted to know if there is a way to call the sp inside the package AND
get the required metadata to make the sp work without the workaround.

I have another doubt regarding how to pass the password of a user to the
SP and getting the driver to mask it. From what i could read if i copy
the password in a <password/> node inside the <jdbc:statement/> node i
should be able to pass it as {$$password} in the <values/> node of the
corresponding <param/> node, but for some reason in the corresponding
table i'm getting the value {$password} and not the actual password.

Here's the policy i'm using: http://pastebin.com/U4Sj6FH4

And this is the trace for the operation: http://pastebin.com/DPc88g8j

Any help will be appreaciated.

Thanks in advance!

EPedros's Profile: https://forums.netiq.com/member.php?userid=5531
View this thread: https://forums.netiq.com/showthread.php?t=53698