Home » Developer & Programmer » Application Express & MOD_PLSQL » need some help with a code in application express
need some help with a code in application express [message #611230] Mon, 31 March 2014 00:38 Go to next message
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!!

Re: need some help with a code in application express [message #611232 is a reply to message #611230] Mon, 31 March 2014 00:41 Go to previous messageGo to next message
BlackSwan
Messages: 22927
Registered: January 2009
Senior Member
Please read and follow the forum guidelines, to enable us to help you:

http://www.orafaq.com/forum/t/88153/0/ and please read http://www.orafaq.com/forum/t/174502/102589/
Re: need some help with a code in application express [message #611234 is a reply to message #611232] Mon, 31 March 2014 00:49 Go to previous message
Littlefoot
Messages: 19711
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
What tool do you use to access your Oracle database? Is it SQL*Plus? Or, by any chance, Apex SQL Workshop? Something different?
Previous Topic: i really need some help!! ( unnamed blocks)
Next Topic: Conditionally Setting background color in apex
Goto Forum:
  


Current Time: Fri Oct 31 17:56:32 CDT 2014

Total time taken to generate the page: 0.97017 seconds