Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

How to trace the errors in pl/sql block code?

Answer Posted / madhuri

SHOW ERROR will show the error code and message in a pl/sql
block.

If you know where exactly the error is then uses number of
dbms statements before/after each sql statement.

Is This Answer Correct ?    5 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is fmtonly in sql?

1077


Why do we use procedures in sql?

1068


Is it mandatory for the primary key to be given a value when a new record is inserted?

1196


What is an alias command?

1057


Does pl/sql support create command?

1099


What are the different datatypes available in PL/SQL?

1081


What are its different types of dbms?

998


what is cursor. write example of it. What are the attributes of cursor.

1377


what is the difference between mysql_fetch_array and mysql_fetch_object? : Sql dba

1053


What is a primary key? Explain

970


Why stored procedure is better than query?

938


What is not null in sql?

1053


What is sql table?

962


What is a crud api?

948


What is database sql?

1039