inserting procedur/function

Hi khushi2003,

From the Oracle Database Concepts document:

=======================
A procedure or function is a schema object that consists of a set of SQL statements and other PL/SQL constructs, grouped together, stored in the database, and run as a unit to solve a specific problem or perform a set of related tasks. Procedures and functions permit the caller to provide parameters that can be input only, output only, or input and output values. Procedures and functions let you combine the ease and flexibility of SQL with the procedural functionality of a structured
programming language. Procedures and functions are identical except that functions always return a single value to the caller, while procedures do not. For simplicity, procedure as used in the remainder of this chapter means procedure or function. You can run a procedure or function interactively by:


* Using an Oracle tool, such as SQL*Plus

* Calling it explicitly in the code of a database application, such as an Oracle Forms or precompiler application

* Calling it explicitly in the code of another procedure or trigger
=======================

If you intend to use SQL*Plus, there is no need to wrap your insert in procedural body. Which parameter do you wish to pass?

So from above example how can i create my procedure or function
and how can i call it?

I am using SQL PLUS

create or replace procedure myproc
as
begin
for x in (select * from customer)
loop
insert into customer1id,name,street_no,street_name,phone)
values(x.id,x.name,substr(x.address,1,instr(x.address,' ',1)-1),substr(x.address,instr(x.address,' ',1)+1),x.phone);
end loop;
commit;
end;

and from sql*plus, you will:

SQL> execute myproc;

OR

SQL> begin
          myproc;
         end;


HTH

I would like to add some exception code here
i will create customer_exception_table and i want to throw all other data into this table where i can put my exception code in this procedure

i will be creating exception table same as customer just one column added

create table customer
(id number,
name varchar2(30),
address varchar2(60),
phone number,
comment,
primary key(id));

and can i add comment (comment field) on procedure like i want to put "EXPCEPTION" as my comment.

Thanx i am closing this question.....need to ask more on this procedure and function

i mean those data (address) i cannot split that i want to throw into exception table. with comments
regards