stored procedures , using database adapters

Hi,

I want to execute stored procedures while provsioning user on oracle.

I have installed oracle and added oracle resource on IdM. But i guess OOTB oracle adapter doesnt support calling stored procedure.

Can you please let me know, how should i do this? do i need to write custom adapter? anyone has already done it?please do you have any pointers

Thanks,

[387 byte] By [highperformera] at [2007-11-27 10:02:11]

«« how to write data into a file
»» Instantiating an abstract class

# 1

You can use scripted JDBC resource adapter for your functionality.

sivapraturia at 2007-7-13 0:36:23 >

top of Java-index,Web & Directory Servers,Directory Servers...

# 2

Hi,

I want to use the sql store procedures and ScriptedJDBC adapter only supports scripts written in JS or BeanShell.

"The customer-supplied scripts called by the Scripted JDBC adapter must be written in Javascript or BeanShell. Identity Manager stores these scripts in the Identity Manager repository as named ResourceAction objects."

so is there any alternative?how can i use custom store procedures to provision user on the oracle

highperformera at 2007-7-13 0:36:23 >

# 3

Why not just extend the out-of-the-box adapter and override the realCreate method. That would be much simpler.

anokun7a at 2007-7-13 0:36:23 >

Java programming resources: FAQs, tutorials, compiler and browser download sites, documentation, books lists, IDEs, etc.

stored procedures , using database adapters

Web & Directory Servers Hot Topic

Web & Directory Servers

All Classified