How to create a simple Oracle Stored Procedure

Source: Network/Editor: getting started with programming: Unknown

Connect:

Oracle9i Enterprise Edition Release 9.2.0.1.0-Production

With the partitioning, OLAP and Oracle Data Mining options

Jserver release 9.2.0.1.0-Production

　　SQL> create or replace procedure get_news(
　　 2　aid in varchar2,atitle in varchar2)
　　 3　as
　　 4　begin
　　 5　select * from cf_news
　　 6　end;
　　 7　/

Warning: the creation process has a compilation error.

　　SQL> create or replace procedure get_news(
　　 2　aid in varchar2 ,atitle in varchar2)
　　 3　as
　　 4　beging
　　 5　/

Warning: the creation process has a compilation error.

　　SQL> create or replace procedure get_news(
　　 2　aid in varchar2)
　　 3　as
　　 4　begin
　　 5　select * from cf_news;
　　 6　end;
　　 7　/

Warning: the creation process has a compilation error.

　　SQL> create or replace procedure get_news
　　 2　as
　　 3　begin
　　 4　select * from cf_news;
　　 5　end;
　　 6　/

Warning: the creation process has a compilation error.

SQL> show errors;
Procedure get_news error:
　　
Line/COL Error
---------------------------------------------
4/1 PLS-00428: The into clause is missing in this select statement
SQL> Create or replace procedure get_news
2
3 aA number;
4 begin
5 select count (*) into AA from cf_news;
6 end;
7/

The process has been created.

　　SQL> create or replace procedure get_news
　　 2　as
　　 3　aa number;
　　 4　begin
　　 5　select count(*) into aa from cf_news;
　　 6　dbms_outpub.put_line('aa='||aa);
　　 7　end;
　　 8　/

Warning: the creation process has a compilation error.

SQL> show errors;
Procedure get_news error:
　　
Line/COL Error
-------------------------------------------------
6/1 PLS-00201: The identifier 'dbms _ outpub. put_line 'must be specified'
6/1 PL/SQL: Statement ignored
SQL> Create or replace procedure get_news
2
3 aA number;
4 begin
5 select count (*) into AA from cf_news;
6 dbms_output.put_line ('aa = '| aa );
7 end;
8/

The process has been created.

　　SQL> set serverout on;
　　 SQL> execute get_news;
　　 aa=3

The PL/SQL process is successfully completed.