aspose file tools*
The moose likes JDBC and the fly likes Procedure created with compilation errors. Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC
Bookmark "Procedure created with compilation errors." Watch "Procedure created with compilation errors." New topic
Author

Procedure created with compilation errors.

Ravi Kiran Va
Ranch Hand

Joined: Apr 18, 2009
Posts: 2234

Hi ,

I am new to PL/SQL development .

When i am creating a basic Stored Procedure for example the below one :


I am getting


Save India From Corruption - Anna Hazare.
Siva Masilamani
Ranch Hand

Joined: Sep 19, 2008
Posts: 385
put "show errors" at the end (after END; )and see what is the error?


SCJP 6,SCWCD 5,SCBCD 5

Failure is not an option.
Paul Sturrock
Bartender

Joined: Apr 14, 2004
Posts: 10336

If you are new to PL/SQL you will get great benefit from reading the chapter in the oracle documentation called "Handling PL/SQL Errors". It will tell you how to show what the error is.


JavaRanch FAQ HowToAskQuestionsOnJavaRanch
Ravi Kiran Va
Ranch Hand

Joined: Apr 18, 2009
Posts: 2234

Thank you very much.
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Procedure created with compilation errors.