| need some help with a code in application express [message #611230] |
Mon, 31 March 2014 00:38  |
 |
reuben123
Messages: 4
Registered: March 2014
Location: India
|
Junior Member |
|
|
Hello!
I am new in oracle and have just started out with some basic commands.
I use oracle 11g application express( the one that oracle lets you download for free)
Right now i am learning the concept of procedures.
so i type in this procedure :
CREATE OR REPLACE PROCEDURE class_pro(new_class IN OUT student.class%TYPE)
IS
BEGIN
new_class := new_class+1;
END class_pro;
/
oracle tells me that procedure is created.
But when i try to run the procedure
VARIABLE new_no NUMBER
class_pro(:new_no);
print new_no;
it says invalid statement.
please help!!
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
