Results 1 to 3 of 3
  1. #1
    Join Date
    Jan 2010
    Posts
    29

    Unanswered: how to excecute a procedure from package in toad by using parametrs

    Hello all

    I am trying to excecute a procedure from package in toad,But it is erroring out because of parameter values

    Here is what i am doing:

    BEGIN
    AB_3_1_ABC_CAD_CAB_DATA_test.AB_e_3_08_tem_ABCD;
    END;

    and also

    BEGIN
    AB_3_1_ABC_CAD_CAB_DATA_test.AB_e_3_08_tem_ABCD (p_run_no IN NUMBER)
    ;
    END;


    above script is not working to run proc from PKG

    here is my proc looks like:

    PROCEDURE AB_e_3_08_tem_ABCD(p_run_no IN NUMBER)
    IS
    v_err_code VARCHAR2(50);
    v_err_msg VARCHAR2(2100);
    v_dml_type VARCHAR2(50);
    v_source_table VARCHAR2(30);
    v_target_table VARCHAR2(30);
    v_status VARCHAR2(100);
    --original variables
    procid CONSTANT CHAR(10) := 'GETVIPDATA';
    stepnum CONSTANT NUMBER := 3.5;
    blankrows NUMBER;
    allrows NUMBER;
    leftrows NUMBER;
    strcreate CHAR(2000);

    begin
    -------
    -----
    end;


    Can anybody please help me how to run procedure from package in toad wich have IN parameters




    Thanks in advance!!
    Hasya

  2. #2
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    BEGIN
    AB_3_1_ABC_CAD_CAB_DATA_test.AB_e_3_08_tem_ABCD (0)
    ;
    END;
    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.

  3. #3
    Join Date
    Jan 2010
    Posts
    29
    Thanks you very much for quick reply!!

Posting Permissions

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