How to execute packaged stored procedure from SQL*Plus. My main concen is, to know execution elapsed time for each packaged stored procedure.
For example I have following packaged procedure
p_ani IN VARCHAR2,
p_dnis IN VARCHAR2,
p_MaxPort IN NUMBER,
p_STATUS OUT INT,
p_SERVICE_TYPE OUT PLS_INTEGER,
p_ISSUER_ID OUT VARCHAR2,
p_PLAY_MSG OUT PLS_INTEGER,
p_GREETING_MSG OUT VARCHAR2,
p_LANG_SELECTION OUT VARCHAR2,
p_ANI_AUTHORIZATION OUT PLS_INTEGER,
p_PIN_AUTHORIZATION OUT PLS_INTEGER,
p_ACC_AUTHORIZATION OUT PLS_INTEGER,
p_LANGUAGE_CODE OUT VARCHAR2,
p_BILLING_GROUP OUT VARCHAR2,
p_ANI_TYPE OUT PLS_INTEGER,
p_Warning_Threshold OUT PLS_INTEGER,
p_userNo OUT VARCHAR2
After completion of the above procedure, i will pass some of the output parameters returned by the above procedure to another packaged stored procedure.. and so on.
So, these tasks, would like to done through SQL*PLUS. So that I can get the elapsed time for each packaged procedure execution.
Any one can suggest me the code to solve my problem.