cdi_rajesh

Thanks for your suggestion and I have tried them already. For some reason my script is not been called out from PROIV. I guess I need to investigate further and try to identify the problem.

Thanks

I tired another approach, instead of using Global Logic, I am using Global Update. Now that I am not getting any error, but the strange part is it’s not executing the SQL block (when I can check on backend, I don’t see any new records).

Strange…!!!???

Sorry i forgot to correct them in the post. But in my actual function they are right (see below) and still having problem.

$_CURFUNCT = 'ABC'
$_ACTION = 'ADD'
$_LINK_FUNCTION = 'MENU'

SQL
DECLARE
v_action VARCHAR2(8) := :$_ACTION;
v_curfunct VARCHAR2(8) := :$_CURFUNCT;
v_link_function VARCHAR2(8) := :$_LINK_FUNCTION;
BEGIN
performance_logging_package.write_pro4_log(v_action, v_curfunct, v_link_function);
END;
ENDSQL

Thanks

Balaram,

The environment u r using might not allow u to do so (lack of permission). check with ur counterpart they should be able to help U or talk to someone.

Hi Seetharam,

If needed I am ready to train your people in Proiv. Do let me know if you are willing to accept my service. Its gonna be a win win situation for both of us.

Regards
Raj