PLS-00049: bad bind variable 'STU_NO' [message #9706] |
Tue, 02 December 2003 04:30 |
omer naj
Messages: 9 Registered: December 2003
|
Junior Member |
|
|
hi
i hope you can help!
i am trying to create the following procedure, but it creates with complilation errors i keep getting the following error and dont know how to fix it.
LINE/COL ERROR
-------- -------------------------------------------
13/28 PLS-00049: bad bind variable 'STU_NO'
22/1 PLS-00103: Encountered the symbol "INSERT"
create or replace procedure add_student
(fname varchar2,
lname varchar2,
astreet varchar2,
acity varchar2,
apostcode varchar2,
cphone varchar2,
dob varchar2)
AS
stu_no number; num number; u_id varchar2(6);
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 || '@gre.ac.uk';
END;
insert into student values (student_type(fname, lname, address_type
(astreet, acity, apostcode, 'UK'), contact_type(cphone, null, em),
to_date(dob),'British','Full',to_char(stu_no),u_id,'Pending'));
commit;
END;
|
|
|
Re: PLS-00049: bad bind variable 'STU_NO' [message #9708 is a reply to message #9706] |
Tue, 02 December 2003 05:11 |
William Robertson
Messages: 1643 Registered: August 2003 Location: London, UK
|
Senior Member |
|
|
:stu_no
indicates a host bind variable e.g. declared in SQL*Plus, Forms etc. A regular PL/SQL variable is just
stu_no
Or maybe even better, use a naming convention to make variables different from database column names, e.g. declare it as v_stu_no.
|
|
|
|