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 schema in sql example?

1159


What are different types of functions in sql?

990


What are the benefits of pl/sql packages?

1091


What are the methods of filing?

919


How do I write a sql query in pgadmin 4?

962


How to select 10 records from a table?

1142


What is the life of an sql statement?

1000


What are the types of triggers in sql?

1067


How do you modify a trigger?

914


what is single byte over head in oracle..?

2389


What is an inconsistent dependency?

1032


What are dml commands?

1002


what is 'mysqld'? : Sql dba

959


What are inner and outer joins examples of both?

940


what is normalization? : Sql dba

1070