2 Replies Latest reply on Jul 8, 2014 3:29 PM by Don G

    Creating the body and the specs in sqldeveloper

    896976

      I just changed jobs, I have been using TOAD for years, my new job use sqldeveloper, I need to create a new package the body is create but not the specs

       

      this is what I am doing

      In a schema  

      under package right click new package

       

      I entered:

       

      SCHEMA: NAME apperas

      Name I enter the name of the package

      I check add new source in lowercase

       

      I got someting like this

       

      create or replace

      package test1 as

       

       

        /* TODO enter package declarations (types, exceptions, methods etc) here */

       

      end test1;

       

      I am used to enter the specs and the body in different files. do I have to enter the specs and the body here...

      Thank you

        • 1. Re: Creating the body and the specs in sqldeveloper
          I need to create a new package the body is create but not the specs

          Well - what you posted shows the SPEC was created:

          create or replace

          package test1 as

          That is the SPEC. The body would start like this:

          create or replace package body test1 as

          • 2. Re: Creating the body and the specs in sqldeveloper
            Don G

            The steps I take to create a Package are as follows

            1. Right click on Packages

            2. Click New Package

            3. Enter the Name of the package in the pop up dialog box and click OK

                This creates the package spec.

            4. Hit the compile button drop down and choose "Compile for Debug"   (It is the gears icon next to the green arrow)

            5. Refresh your Connections box (I have mine set in the upper left)

               You should now see your package spec listed,

            6.Right click on your package spec and choose "Create Body ..."

            This will provide the minimum structure or your package body.

            7. Again click on the "Compile for Debug" icon and now the Package Body is listed below the Package Spec.

             

            Program away after that.