Originally Posted by vinaytp
I am trying to write a simple stored procedure in sql..i am using oracle database...
my stored procedure is as follows..
create or replace procedure getvinay ( )
4 select * from vinay;
what the error here ...can anyone help me please..
thanks in advance.......
Don't know what the error is, since YOU HAVEN'T TOLD US WHAT'S WRONG, OR WHAT ITS DOING. You've just posted a few lines of a stored procedure....and since this is really an Oracle database question, rather than a Linux question, it might be better posted on an Oracle forum.