Home » SQL & PL/SQL » SQL & PL/SQL » Compilation Error in Procedure
Compilation Error in Procedure [message #583029] Thu, 25 April 2013 00:35 Go to next message
agr.mudit
Messages: 1
Registered: April 2013
Location: Chennai
Junior Member
Hi,

I am having 3 procedures a,b,c. Procedure a is calling b,procedure b is calling c, and procedure c is calling procedure a.There is compilation error in procedure a but while compiling it is saying dependent procedure is uncompiled.

How to compile all the 3 procedures..
Re: Compilation Error in Procedure [message #583031 is a reply to message #583029] Thu, 25 April 2013 00:41 Go to previous messageGo to next message
Michel Cadot
Messages: 59994
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Welcome to the forum.

Use SQL*Plus and copy and paste your session, the WHOLE session.

Before, Please read OraFAQ Forum Guide and How to use [code] tags and make your code easier to read.
Make sure that lines of code do not exceed 80 characters when you format.
Indent the code, use code tags and align the columns in result.
Use the "Preview Message" or "Preview Quick Reply" button to verify.
Also always post your Oracle version, with 4 decimals.

With any SQL or PL/SQL question, please, Post a working Test case: create statements for all objects so that we will be able work to reproduce what you have.

Regards
Michel
Re: Compilation Error in Procedure [message #583034 is a reply to message #583031] Thu, 25 April 2013 00:54 Go to previous messageGo to next message
Littlefoot
Messages: 19889
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Quote:
There is compilation error in procedure a

So fix it; then recompile all procedures.
Re: Compilation Error in Procedure [message #583036 is a reply to message #583029] Thu, 25 April 2013 01:01 Go to previous message
flyboy
Messages: 1780
Registered: November 2006
Senior Member
Seems to be the same problem as in this AskTom thread:
http://asktom.oracle.com/pls/asktom/f?p=100:11:::::P11_QUESTION_ID:286816015990
Just follow the advice given there.
Previous Topic: Display conditional column values
Next Topic: Tablespace
Goto Forum:
  


Current Time: Sat Dec 20 01:01:28 CST 2014

Total time taken to generate the page: 0.08626 seconds