how to run a procedure [message #9717] |
Tue, 02 December 2003 06:51 |
omer naj
Messages: 9 Registered: December 2003
|
Junior Member |
|
|
how do i insert values into the following add_student procedure.
create or replace procedure add_student
(fname varchar2,
lname varchar2,
astreet varchar2,
acity varchar2,
apostcode varchar2,
cphone varchar2,
db varchar2)
AS
stu_no number; num number; u_id varchar2(5);
flet varchar2(1); llet varchar2(1); em varchar2(16);
BEGIN
select studno.nextval into stu_no from dual;
flet:=SUBSTR(fname,1,1);
llet:=SUBSTR(lname,1,1);
num:=trunc(abs(dbms_random.random)/power(2,31)*899)+100;
dbms_random.terminate;
u_id:=llet || flet || to_char(num);
em:=u_id || '@gr.ac.uk';
END;
thanks
|
|
|
Re: how to run a procedure [message #9721 is a reply to message #9717] |
Tue, 02 December 2003 07:19 |
|
Maaher
Messages: 7065 Registered: December 2001
|
Senior Member |
|
|
Begin
add_student( 'Some first name'
, 'Some last name'
, 'Street'
, 'Some city'
, 'your postal code'
, 'phone'
, 'db value'
);
end; orSQL> Exec add_student( 'first name','last name','street','city','postal','phone','db')
MHE
|
|
|