Win a copy of The Java Performance Companion this week in the Performance forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

hi,any body can show me a clue?--about store procedure...urgent

 
du sixiang
Greenhorn
Posts: 3
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
create table vip_users
(
vip_cust_no varchar2(18),
vip_card_no varchar2(15),
vip_credit number(10,2),
vip_flag varchar2(1)
)
create table orders_test
(
order_no varchar2(18),
vip_cust_no varchar2(18),
vip_sum number(10,2),
vip_flag varchar2(1)
)
create procedure proc_test(
order_novarchar2(18),
order_sumnumber(10,2),
vip_cust_novarchar2(18))
as
begin
insert into orders_test(order_no,vip_cust_no,vip_sum,vip_flag)
values (order_no,vip_cust_no,order_sum,'1')
update vip_users set vip_credit=vip_credit+vip_sum
commit;
end;
why my cursor not exit from the sql> promote window to unix promote window to show me success?
 
SJ Adnams
Ranch Hand
Posts: 925
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
/
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic