Results 1 to 7 of 7
  1. #1
    Join Date
    Feb 2012
    Posts
    36

    Unanswered: Is it possible to call multiple plsql procedures / functions in a single plsql functi

    Dear All,

    Is it possible to call multiple plsql procedures / functions in a single plsql Procedure ??

    If yes can some body pls suggest with a short example ??

  2. #2
    Join Date
    Dec 2007
    Posts
    253
    Have you tried it? What happened, show us the code.

  3. #3
    Join Date
    Feb 2012
    Posts
    36
    CREATE OR REPLACE PROCEDURE SYSTEM.datafix
    as

    Begin

    Fn_Entity_Tmp_00;

    end;

    begin

    Fn_Matching_Entity_Tmp_00;

    end;
    /


    Thanks for the reply bro, i hope i got it solved, I hope this code would work is it ??

  4. #4
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    Code:
    CREATE OR replace PROCEDURE SYSTEM.Datafix 
    AS 
    BEGIN 
        fn_entity_tmp_00; 
    
        fn_matching_entity_tmp_00; 
    END; 
    
    /
    > i hope i got it solved, I hope this code would work is it ??
    no
    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.

  5. #5
    Join Date
    Dec 2007
    Posts
    253
    Quote Originally Posted by ijunaid View Post
    CREATE OR REPLACE PROCEDURE SYSTEM.datafix
    as

    Begin

    Fn_Entity_Tmp_00;

    end;

    begin

    Fn_Matching_Entity_Tmp_00;

    end;
    /


    Thanks for the reply bro, i hope i got it solved, I hope this code would work is it ??
    Close but no cigar
    You can see from anacedent's reply how close. One other thing, your naming convention implies that you are calling functions, if that is the case,then the code will fail as you need to assign the output of the function to a variable.
    e.g.
    varname := fn_entity_tmp_00;

  6. #6
    Join Date
    Jan 2004
    Location
    Croatia, Europe
    Posts
    4,094
    Provided Answers: 4
    Additionally, it appears that you chose to create that procedure as SYSTEM. That's a BIG mistake. Let SYS & SYSTEM alone. Pretend they don't exist.

  7. #7
    Join Date
    Feb 2012
    Posts
    36
    Thanks for all ur suggestions

Posting Permissions

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