Quick Search:
CODE
Oracle PL/SQL Code Library
JOBS
Find Or Post Oracle Jobs
FORUM
Oracle Discussion & Chat
 Oracle PL/SQL: PACKAGES: one procedure Jump to:  
Category: >> Oracle PL/SQL >> PACKAGES: one procedure Bookmark and Share

<< lastnext >>

Snippet Name: PACKAGES: one procedure

Description: This is a bare-bones package example with both the package specification and the package body.

Also see:
» PACKAGES: initialization
» PACKAGES: related queries
» PACKAGES: alter package
» PACKAGES: overloading
» PACKAGES: one function
» UTL_FILE file write to file example
» Create Package
» UTL_FILE import data

Comment: (none)

Language: PL/SQL
Highlight Mode: PLSQL
Last Modified: March 10th, 2009

CREATE OR REPLACE PACKAGE <package_name> AS
PROCEDURE <procedure_name> (<parameters>);
END <package_name>;
/
 
PROCEDURE <procedure_name> (<parameters>) IS
<define local variables, constants, AND exceptions>
BEGIN
  <procedure_code>;
END <procedure_name>;
 
===============================
 
CREATE OR REPLACE PACKAGE test1 AS
PROCEDURE get_table_names(number_in IN PLS_INTEGER);
END test1;
/
 
CREATE OR REPLACE PACKAGE BODY test1 AS
PROCEDURE get_table_names(number_in IN PLS_INTEGER) IS
 tabname user_tables.table_name%TYPE; 
BEGIN
  SELECT table_name
  INTO tabname
  FROM user_tables
  WHERE ROWNUM < number_in;
 
  DBMS_OUTPUT.put_line(tabname); 
EXCEPTION
  WHEN OTHERS THEN
    DBMS_OUTPUT.put_line('Something went wrong'); 
 END get_table_names;
END test1;
/


Free
Oracle Magazine
Subscriptions
and Oracle White Papers


SQL University.net courses meet the most demanding needs of the business world for advanced education in a cost-effective manner. SQL University.net courses are available immediately for IT professionals and can be taken without disruption of your workplace schedule or processes.

Compared to traditional travel-based training, SQL University.net saves time and valuable corporate resources, allowing companies to do more with less. That's our mission, and that's what we deliver.

Click here to find out more
 
Home      :      Code Library      :      Sponsors      :      Privacy      :      Terms of Use      :      Contact Us 303 users online    © 2009 psoug.org

PSOUG LOGIN
Username: 
Password: 
Forgot your password?