hi all,
I encountered a problem.
The table structure is as follows:
create table express_info
(
exp_num char(10) not null,
ori_station char(8),
dest_station char(8),
consignee char(8),
shipping_address char(50),
qty number,
constraint pk_exp primary key(exp_num)
)
--------------------------------------------
create or replace procedure update_traninfo
( en char,
os char,
ds char,
ce char,
sa char,
qy numer
)
is
begin
update express_info set ori_station=os,dest_station=ds,
consignee=ce,shipping_address=sa,
qty=qy
where exp_num=en;
end update_traninfo;
---------------------------------------
The above SQL statement can successfully compile and build a successful.
but,Error when the execution,The error message is as follows:
invalid SQL statement.
now,I just want to know the syntax of the stored procedure Existence problem?
thanks in advance.
Loading

pundaleek channalPosted May 23, 2012, 6:03 AM
( en IN express_info.exp_num%type,
os IN express_info.ori_station%type,
ds IN express_info.dest_station%type,
ce IN express_info.consignee%type,
sa IN express_info.shipping_address%type,
qy IN express_info.qty%type
)
is
begin
update express_info
set ori_station=os,
dest_station=ds,
consignee=ce,
shipping_address=sa,
qty=qy
where exp_num=en;
end;
Run this code and check, problem in parameter declaration..