Results 1 to 2 of 2
  1. #1
    Join Date
    Mar 2005
    Posts
    41

    Unanswered: Execute multiple procedures in a parallel state

    I am wondering how can I execute all individual procedures in parallel state in following script using sqlplus. I know I can create individual script for each procedure and execute it in different oracle sqlplus session but that solution is not viable.

    Declare
    Vld_ref_dt_i date;
    BEGIN
    EDW_ODS_SIT.QA_USER_LOOKUP.USR_LKP_SUPPORTFORCE_CN T (to_date('12/31/2009','mm/dd/yyyy')); COMMIT;
    EDW_ODS_SIT.QA_USER_LOOKUP.USR_LKP_USER_ID_CNT (to_date('12/31/2009','mm/dd/yyyy')); COMMIT;
    EDW_ODS_SIT.QA_USER_LOOKUP.USR_LKP_USER_LICENSE_ID _CNT (to_date('12/31/2009','mm/dd/yyyy')); COMMIT;
    EDW_ODS_SIT.QA_USER_LOOKUP.USR_LKP_USERNAME_EML_CN T (to_date('12/31/2009','mm/dd/yyyy')); COMMIT;
    EDW_ODS_SIT.QA_USER_LOOKUP.USR_LKP_USER_ROLE_ID_CN T (to_date('12/31/2009','mm/dd/yyyy')); COMMIT;
    EDW_ODS_SIT.QA_USER_LOOKUP.USR_LKP_USR_LOGIN_CNT (to_date('12/31/2009','mm/dd/yyyy')); COMMIT;

    END;

    /

    exit;

  2. #2
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    >execute it in different oracle sqlplus session but that solution is not viable.
    SQL*Plus does not do parallel.
    You might be able to obtain desired results via DBMS_JOB; but it won't be pretty or easy.
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •