wood burning stoves*
The moose likes JDBC and the fly likes hi,any body can show me a clue?--about store procedure...urgent Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC
Bookmark "hi,any body can show me a clue?--about store procedure...urgent" Watch "hi,any body can show me a clue?--about store procedure...urgent" New topic
Author

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

du sixiang
Greenhorn

Joined: Mar 10, 2003
Posts: 3
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

Joined: Sep 28, 2001
Posts: 925
/
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: hi,any body can show me a clue?--about store procedure...urgent