Results 1 to 4 of 4
  1. #1
    Join Date
    Feb 2004
    Posts
    93

    Unanswered: how to create a package

    I need to load 4 procedures into one package so I can load into UNX.

    can someone tell me how to put 4 procedures into one package?

    And also I want to use Calling procedure and Shell Script in Unix..Basically i just want to do the following:

    Create a package (pck)
    create a calling procedure to run the package
    create a shell script (.sh) to call the pck....
    Cheers
    Etravels

  2. #2
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    >can someone tell me how to put 4 procedures into one package?
    use vi, vim, emacs, TOAD or the editor of your choosing.
    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
    Feb 2004
    Posts
    93

    any more hints

    Originally posted by anacedent
    >can someone tell me how to put 4 procedures into one package?
    use vi, vim, emacs, TOAD or the editor of your choosing.
    thanks but can you give me some hints as to put the 4 procedures into 1 package...

    cheers
    Cheers
    Etravels

  4. #4
    Join Date
    Jan 2004
    Location
    Croatia, Europe
    Posts
    4,094
    Provided Answers: 4
    First, create a package:
    PHP Code:
    CREATE OR REPLACE PACKAGE pkg_example AS
      
    proc1;
      
    proc2;
      
    proc3;
      
    proc4;
    END pkg_example
    Then you have to include them into the package body:
    PHP Code:
    CREATE OR REPLACE PACKAGE BODY pkg_example AS

      
    proc1 AS
        
    BEGIN
        
    ...
        
    END proc1;

      ...

      
    proc4 AS
        
    BEGIN
        
    ...
        
    END proc4;
    END pkg_example
    Of course, "use vi, vim, emacs, TOAD or the editor of your choosing."

Posting Permissions

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