LinuxQuestions.org
Help answer threads with 0 replies.
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - Newbie
User Name
Password
Linux - Newbie This Linux forum is for members that are new to Linux.
Just starting out and have a question? If it is not in the man pages or the how-to's this is the place!

Notices


Reply
  Search this Thread
Old 06-13-2009, 07:18 AM   #1
vinaytp
Member
 
Registered: Apr 2009
Location: Bengaluru, India
Distribution: RHEL 5.4, 6.0, Ubuntu 10.04
Posts: 704

Rep: Reputation: 55
procedrue created with compilation errors


hi all.....

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 ( )
2 as
3 begin
4 select * from vinay;
5 end;
6 /

what the error here ...can anyone help me please..

thanks in advance.......
 
Old 06-13-2009, 01:59 PM   #2
TB0ne
LQ Guru
 
Registered: Jul 2003
Location: Birmingham, Alabama
Distribution: SuSE, RedHat, Slack,CentOS
Posts: 18,504

Rep: Reputation: 3993Reputation: 3993Reputation: 3993Reputation: 3993Reputation: 3993Reputation: 3993Reputation: 3993Reputation: 3993Reputation: 3993Reputation: 3993Reputation: 3993
Quote:
Originally Posted by vinaytp View Post
hi all.....

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 ( )
2 as
3 begin
4 select * from vinay;
5 end;
6 /

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.
 
  


Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off



Similar Threads
Thread Thread Starter Forum Replies Last Post
Qt Compilation Errors grsandeep85 Linux - Newbie 3 05-10-2009 03:07 AM
compilation errors in g++ manikan Linux - Software 1 02-03-2006 05:31 AM
C++ compilation errors ??? glevine Programming 1 07-16-2004 03:15 PM
Compilation Errors ! vipinsharma Programming 0 06-01-2004 02:24 AM
kernel compilation errors spork545 Red Hat 4 10-15-2003 08:03 PM


All times are GMT -5. The time now is 01:45 PM.

Main Menu
Advertisement
My LQ
Write for LQ
LinuxQuestions.org is looking for people interested in writing Editorials, Articles, Reviews, and more. If you'd like to contribute content, let us know.
Main Menu
Syndicate
RSS1  Latest Threads
RSS1  LQ News
Twitter: @linuxquestions
Facebook: linuxquestions Google+: linuxquestions
Open Source Consulting | Domain Registration