| Why not in a single procedure??? [message #359973] |
Wed, 19 November 2008 00:55  |
modhiyakomal
Messages: 49
Registered: November 2008
Location: US
|
Member |
|
|
Hi All,
here my procedure is
create or replace procedure pr2(sales_org1 IN s_delivery.created_by%type, date1 s_delivery.creation_date%type,date2 s_delivery.creation_date%type)
is
a1 varchar2(30);
a2 varchar2(30);
a3 timestamp;
a4 date;
a5 number;
a6 varchar2(30);
begin
select sd.sales_org, sd.created_by,sd.creation_time,sd.creation_date, sd.ship_to_party, sp.name into a1,a2,a3,a4,a5,a6
from s_delivery sd, s_partner sp
where( (sd.ship_to_party = sp.partner_no) AND (sales_org1=sd.created_by) AND (creation_date between date1 AND date2));
delete from t1;
insert into t1 values(a1,a2,a3,a4,a5,a6);
end;
this procedure executes succesfully..
but if i want to print values of table t1,, is it possible to add select * into same code?
i want o/p in same procedure execution only once.
thanks
|
|
|
|
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
