|
-
set timing on
as for passing parameters type OUT you could use bind variables for example
variable p_STATUS number
PROCEDURE twoStage_firstAuthorize(
p_ani IN VARCHAR2,
p_dnis IN VARCHAR2,
p_MaxPort IN NUMBER,
v_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
)
............
:v_STATUS := v_STATUS;
............
/
then next procedure would use :v_STATUS as parameter IN
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|