Hi,
I see two ways how to do this (if I understood corectly)
1. You can just add a procedure call in your PLSQL function (but I think
this case you tried)
2. You can build some kind of proxy function, that you will call in APP
in this way:
CREATE FUNCTION proxy_fnc (params) return result_type
AS
DECLARE
result result_type;
BEGIN
result = monitored_fnc;
stored_proc(params2);
return result;
END;
And you just switch the calling to proxy_fnc in your application
(that's how I understood your problem)
hoppo
On 4.11.2009 14:54, Vlad wrote:
> My requirement is that I have an existing function that is used very
> infrequently by a single function in my application. I have another
> existing stored procedure.
>
> I want the stored procedure to be executed every time a query uses the
> database function.
>
> I appreciate my requirements may sound a bit illogical but I am
> constrained by a number of factors - I'm kind of trying to put a
> square peg through a round hole.
>
> Let me know if this still doesn't make sense and I'll have another go.
> >
>
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google
Groups "Oracle PL/SQL" group.
To post to this group, send email to Oracle-PLSQL@googlegroups.com
To unsubscribe from this group, send email to
oracle-plsql-unsubscr...@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/Oracle-PLSQL?hl=en
-~----------~----~----~----~------~----~------~--~---
