Question hi . I have written a function which calls a stored procedure. A single parameter is passed to function,from which some information are retrieved and those information is passed to the called procedure to update the tables. As the called procedure is encoded i cannot see the codes inside it. I can only see the output of that procedure in a table.
As i know function cannot perform DML statements...then how will I call the procedure.
Answer Hi bandana.
I could not understand your question well.
What you want is to know the name of the procedure?
If so, make a select from all_dependencies, and see the dependencies of the function.
What you want is to call the procedure (?)?
Ifo so, try (if itīs the case) to use execute immediate 'begin proc_name;end;'
