Procedures in Oracle
Posted on 2009-04-06
Can a procedure be called if its name is contained in a variable name?
I have a configuration table named "MY_CONFIG" having columns as source, request, succes_procedure.
Data will be like this :
Source Request Success_proc
S1 R1 Update_S1
S2 R2 Update_S2
S3 R3 null
I have another table where based on source and request and some other manipulations I have to update a status.
Table is like this
UniqueID Source Request Status
1 S1 R1 Success
2 S2 R2 Faled.
If status is success and if there is an ebtry in success_proc column of table my_config, I have to do some more updates in tables.
I want to check in proceudre that if success procedure is present or not for a source and request like
SELECT success_proc into var_proc
where source = S1 and request = R1;
Is there any way by which I can call proc like this :
var_proc and pass the required parameters to it