Collector using a stored Procedure?

[RodrigodeFreita]

Hello

Have a question about collectors.

It is possible to configure a procedure on collectors.

I have a procedure that returns the rights of an application in two columns (CODE, DESCRIPTION) it is possible to configure this procedure in a collector.

Thank you

[AhmedNofal · Accepted solution]

Hi Rodrigo,

you can implement some custom PL/SQL logic that runs during the folllowing phases in the post processing handler package:

• Post_ID_Unification_Handler 

• Pre_Supervisor_Resolution

• Post_Account_Data_Load_Handler

• Post_MAEDC_Load_Handler

• Post_DADC_Load_Handler

While this might answer your request here, we don't recommend the use of this capability except if it would be the last option (as it would count as a customization that would need to be maintained and taken care of, especially with version upgrades/database upgrades/schema changes), so can I know more about the use case you are trying to solve/achieve here?

[IanStaines]

Are you asking about calling an Oracle (or Microsoft) stored procedure as part of the query string for a "Database" collector type?  

No.   The stored procedure exists only on the (external) datasource.  You cannot call it directly using SQL. 

[IanStaines]

Rodrigo de Freitas Ribeiro‌ did this information help you?

[IanStaines]

No follow-up questions so I am going to mark this thread as answered.