ea

God's Plan For Mental Health

Mental health problems, it appears, have escalated dramatically in recent times. Does the Bible have anything to say about our minds, how we can protect them and solutions to mental ill-health? The answer is 'Yes!'. There is power in the gospel and the Word of God to heal our minds. God has given us a plan of wholeness and healing for our minds. Join us for valuable guidance from Philippians 4:6-9. This message is available at https://www.preachtheword.com now in MP3 audio format...



  • Religion & Spirituality

ea

The Healing Presence

The power to save, heal and set free is God's power. In this healing story from Luke 5:17, we see God's power was present with Jesus to heal. We need to practice God's healing presence rather than the presence of sickness, darkness, Satan or sin. So often, when we face such obstacles, we focus on the problem, but the answer to our problems is never in the problem. The healing presence is where we must abide. This message is available at https://www.preachtheword.com now in MP3 audio format...



  • Religion & Spirituality

ea

Don't Fear, Only Believe

In this story of two overlapping healings - the woman with the issue of blood and the raising of Jairus' daughter - we learn some principles of how God heals. Sometimes, we can be confused about how God does His healing work. In this account, Jesus emphasises the importance of saying 'No' to fear and only believing what God has said. Don't fear, only believe! This message is available at https://www.preachtheword.com now in MP3 audio format...



  • Religion & Spirituality

ea

The Healing Of A Deaf And Mute Man

What a predicament to be both deaf and mute - cut off from communication and the community. Here was a man who exemplified not only those with similar physical impediments but also the spiritual condition of humanity. Yet a physical healing took place for this man in a rather unconventional manner. Here, we learn how God's methods are not always reasonable to us. There is a beautiful revelation in this 'Healing Of A Deaf And Mute Man' of the unique ways God moves with each of us and how compassionate and considerate He is to us as individuals. This message is available at https://www.preachtheword.com now in MP3 audio format...



  • Religion & Spirituality

ea

Great Faith Of A Gentile Woman

This intriguing story of the Syrophoenician woman in Matthew 15:21-31 raises many questions for us, not least how incongruent Jesus' words and behaviour seem, in contrast to what we know and love about His character and personality. Like Jesus did with the woman, this story invites us to probe deeper into its not so obvious meaning. What is Jesus up to in this rather atypical behaviour? There are actually some precious lessons here on the nature of God revealed in Christ, the wideness of God's grace to the whole world and the type of faith that Jesus encourages us to have and responds to. This message is available at https://www.preachtheword.com now in MP3 audio format...



  • Religion & Spirituality

ea

Visión Innovadora para Proteger Áreas DANA y Preservar el Empleo

La reciente DANA (Depresión Aislada en Niveles Altos) que ha afectado a varias regiones ha evidenciado la necesidad de implementar medidas de protección a largo plazo para mitigar cualquier repercusión futura. Este fenómeno meteorológico ha causado daños considerables, subrayando la urgencia de establecer políticas que no solo respondan a las necesidades inmediatas de los afectados, […]

Artículo publicado en : Visión Innovadora para Proteger Áreas DANA y Preservar el Empleo




ea

Transformación Gastronómica: Antiguo Convento de Las Terreras en Ciudad Real Recibe 1,5 Millones en Inversión

El emblemático convento de la Inmaculada Concepción de Ciudad Real, conocido como el convento de las Terreras, se prepara para una transformación significativa que lo convertirá en un centro de interpretación dedicado a la gastronomía manchega. Esta ambiciosa iniciativa, que busca revitalizar el patrimonio cultural de la ciudad, cuenta con una inversión de 1,5 millones […]

Artículo publicado en : Transformación Gastronómica: Antiguo Convento de Las Terreras en Ciudad Real Recibe 1,5 Millones en Inversión




ea

Ciudad Real Se Prepara Para Implementar La Zona De Bajas Emisiones Que Optimizará El Aire Y La Movilidad

El Ayuntamiento de Ciudad Real está reconsiderando el calendario para la implantación de la zona de bajas emisiones (ZBE) en la ciudad. Esta decisión responde a la necesidad de llevar a cabo un exhaustivo estudio jurídico del borrador de la ordenanza elaborada por la Concejalía de Movilidad. El objetivo es evitar «problemas jurídicos» como los […]

Artículo publicado en : Ciudad Real Se Prepara Para Implementar La Zona De Bajas Emisiones Que Optimizará El Aire Y La Movilidad




ea

Page Celebra la Creación del Alto Comisionado y Exige al Estado Compromiso en la Restauración de los Cauces

El presidente de Castilla-La Mancha, Emiliano García-Page, ha mostrado su satisfacción por la decisión del Gobierno central de crear un Alto Comisionado destinado a agilizar la reconstrucción en las zonas afectadas por la reciente DANA (Depresión Aislada en Niveles Altos). Durante un discurso en Puertollano, García-Page expresó su confianza en que la Administración central no […]

Artículo publicado en : Page Celebra la Creación del Alto Comisionado y Exige al Estado Compromiso en la Restauración de los Cauces




ea

Adventures of Man in the Can - Ch 12 - The Great Exodus - Destruction is Coming

Now that the holidays are over the Adventures of the Man in the Can are back!

The Man in the Can, Yellow Bird and all the animals in the park rejoice as the elder birds return to their homes in the park. But in their celebration, everyone fails to notice changes that are beginning to happen all around them.



MP3 File - Click Here to Download Podcast




GREAT DEALS FOR LISTENERS! CLICK BELOW
!


Save 10% on all your pet's needs at PetMeds.com
Up to 20% off on great athletic gear at Eastbay.com
Save 15% on your favorite stuff at Footlocker.com
Save 20% on your flower order with FTD Fluerop.com
Save $10 off your next order from PetCareRX.com





ea

Adventures of Man in the Can - Ch 13 - The Great Exodus - Retreat to the Sewers



Yellow Bird, Man in the Can and the creatures in the park all decide to escape the overhaul of the park by escaping into the sewers. But will they be able to pull off their exit plan in time?

Find out in this episode of The Man in the Can.



MP3 File - Click Here to Download Podcast




GREAT DEALS FOR LISTENERS! CLICK BELOW
!


Save 10% on all your pet's needs at PetMeds.com
Up to 20% off on great athletic gear at Eastbay.com
Save 15% on your favorite stuff at Footlocker.com
Save 20% on your flower order with FTD Fluerop.com
Save $10 off your next order from PetCareRX.com





ea

Adventures of Man in the Can - Ch 14 - The Great Exodus - No One Left Behind



The destruction of the park has begun!! The Man in the Can quickly realizes a family of squirrels is in the mist of the mayhem. Can Yellow Bird and Man in the Can save the family?

Find out in this episode of The Adventures of the Man in the Can.



MP3 File - Click Here to Download Podcast




GREAT DEALS FOR LISTENERS! CLICK BELOW
!


Save 10% on all your pet's needs at PetMeds.com
Up to 20% off on great athletic gear at Eastbay.com
Save 15% on your favorite stuff at Footlocker.com
Save 20% on your flower order with FTD Fluerop.com
Save $10 off your next order from PetCareRX.com





ea

Adventures of Man in the Can - Ch 15 - The Great Exodus - Lost in the Sewers



The Man in the Can and the squirrel family have made it into the sewers. However, they are far from the other animals, and the sewer is a maze. Will they find the others?

Find out in today's episode of the Adventures of the Man in the Can.




MP3 File - Click Here to Download Podcast




GREAT DEALS FOR LISTENERS! CLICK BELOW
!


Save 10% on all your pet's needs at PetMeds.com
Up to 20% off on great athletic gear at Eastbay.com
Save 15% on your favorite stuff at Footlocker.com
Save 20% on your flower order with FTD Fluerop.com
Save $10 off your next order from PetCareRX.com




ea

Adventures of Man in the Can - Ch 16 - The Great Exodus - A Call in the Dark



The Man in the Can and the squirrels become more and more lost in the sewers. It is becoming dark and about to rain. Will Banty the Mouse and the rescue teams find them in time?

Listen in and find out what happens on today's episode of the Adventures of Man in the Can.




MP3 File - Click Here to Download Podcast




GREAT DEALS FOR LISTENERS! CLICK BELOW
!


Save 10% on all your pet's needs at PetMeds.com
Up to 20% off on great athletic gear at Eastbay.com
Save 15% on your favorite stuff at Footlocker.com
Save 20% on your flower order with FTD Fluerop.com
Save $10 off your next order from PetCareRX.com




ea

Adventures of Man in the Can - Ch 17 - The Great Exodus - The River



The Man in the Can and the animals from the park begin their trip down the river to the safe place found by the scout birds. What will be waiting for them on their journey?




MP3 File - Click Here to Download Podcast





GREAT DEALS FOR LISTENERS! CLICK BELOW
!


Save 10% on all your pet's needs at PetMeds.com
Up to 20% off on great athletic gear at Eastbay.com
Save 15% on your favorite stuff at Footlocker.com
Save 20% on your flower order with FTD Fluerop.com
Save $10 off your next order from PetCareRX.com




ea

Adventures of Man in the Can - Ch 18 - The Great Exodus - Predator Eyes



The animals float past the dump and their arch enemies BYDYS the Snake Lord and Greystrike the Rat King. But they are watched in the darkness by the eyes of two predators, Crag the Crow and Baron the Wolf. What will happen next?

Find out in today's Adventures of the Man in the Can.




MP3 File - Click Here to Download Podcast





GREAT DEALS FOR LISTENERS! CLICK BELOW
!


Save 10% on all your pet's needs at PetMeds.com
Up to 20% off on great athletic gear at Eastbay.com
Save 15% on your favorite stuff at Footlocker.com
Save 20% on your flower order with FTD Fluerop.com
Save $10 off your next order from PetCareRX.com




ea

Adventures of Man in the Can - Ch 19 - The Great Exodus - Alliances



The animals sleep as the remaining team of scout birds return and report the findings on their future home. What news will they bring back to Man in the Can and Yellow Bird?

Find out in today's Adventures of the Man in the Can.




MP3 File - Click Here to Download Podcast





GREAT DEALS FOR LISTENERS! CLICK BELOW
!


Save 10% on all your pet's needs at PetMeds.com
Up to 20% off on great athletic gear at Eastbay.com
Save 15% on your favorite stuff at Footlocker.com
Save 20% on your flower order with FTD Fluerop.com
Save $10 off your next order from PetCareRX.com




ea

Adventures of Man in the Can - Ch 20 - The Great Exodus Epilogue



The animals from the park have found a home and made some new and powerful friends. But what will be waiting for them when they go back to the park?

Find out what happens on today's episode of the Man in the Can.




MP3 File - Click Here to Download Podcast





GREAT DEALS FOR LISTENERS! CLICK BELOW
!


Save 10% on all your pet's needs at PetMeds.com
Up to 20% off on great athletic gear at Eastbay.com
Save 15% on your favorite stuff at Footlocker.com
Save 20% on your flower order with FTD Fluerop.com
Save $10 off your next order from PetCareRX.com




ea

The Great Food Waste Scandal.



As austerity measures bite and the Condems seem to be trying to do away with the welfare state altogether and just leave us all to starve I like many others have been forced to use food banks and places that serve hot meals to those who have fallen on hard times. My local place in Ryde on the Isle Of Wight is called "The Open Arms" and takes place in the local methodist church hall (Garfield Road) once a week on a Sunday evening. The provide food for the homeless and for hungry people who are short of money for whatever reason.

I have become friends with those that organise the proceedings there and learned how they get the food they serve. Most of it is donated by local business's but so far big supermarkets have refused to donate the surplus food that they actually throw away despite it still being fit for consumption. 

The Food waste facts are grim, an estimated 400,000 tonnes of food according to food cycle  could be reclaimed from retailers every year if they would just hand it over. Sadly in our experience only small local businesses with a social conscience have actually given us anything, large retailers like Tesco and Iceland refuse to give us the food they would otherwise throw away.

Right now I am roasting carrots and potatoes and making carrot and potato soup out of surplus vegetables kindly given to me by the folk at open arms that would otherwise have been thrown away. They were donated by the local farmers market I believe. There are still some left I didn't have the time to chop so I'll be making more tomorrow. It infuriates me and many others that so much food is wasted while people starve, and here are two campaigns you can join if you feel similarly angry at this and want to fight for food waste prevention.

Food Cycle collect surplus food and cook it for the disadvantaged at several hubs around the country, sadly they aren't going to open anymore hubs but check if there is one near you you could volunteer at if you are interested.

Feed The 5000 Invite you to sign a pledge to reduce your own food waste and encourage businesses to do the same. And also run a great scheme where farmers allow volunteers to go in and harvest crops that would otherwise be re-plowed into the soil as they are surplus or not cosmetically good enough to be sold in shops.This kind of eco food recycling and reclaiming is great and we are looking into doing this on the Island too.

Finished the soup and roasted veg by the way, smells lovely, and to think it would have all just been thrown away if no one claimed it!




ea

Atos Are The Number One Provder of Occupatuional Health Services In The UK.


Last night I was furious to discover that giant multinational IT company Atos is not only responsible for administering the government's hellish Work Capability Assessment, they have also been providing occupational health services in this country for years too, in 2010 they even won an award for it.

So they are declaring the sick capable of work, then if you are lucky enough to get a job (if your not one of more than half the people declared fit for work who end up destitute) you will still probably have to put up with them telling you how much time you can have off when your illness returns. As none of these people being declared fit for work have actually got better, they are just expected to work around their disability, so there is no escape from the bastards it seems.

Yesterday I learned that Co-Op uses their occupational health services, so much for ethics eh? They have posted a statement saying they can't just close the contract but will consider not renewing it. So DPAC are encouraging people to boycott them and go and inform them of this on their facebook page, at least until they issue a statement saying they definitely won't renew the contract.

I did some digging last night and found that:
 
And two county councils I found also use them

Since they are apparently the number one provider of Occupational health services in the UK there must be many more companies and councils using them too, and I saw lots of job vacancies for them posted all over the country.

This post informs you of much money they are raking in with double digit growth in the UK this year, as lives are daily ruined and even ended by the software they own the copyright to. And I'm also learning that this huge multinational company owns oil companies (including Shell and Esso), electronics manufacturers and many more highly profitable companies, more on that to come as I collect the evidence.




ea

the real miami

more)




ea

gringo dreams of a home



(more)




ea

C'est Beau la Rupture !

Le Gouvernement de Nico est pleinement investi des ses responsabilité concernant le bien-être des Français. Dans un souci sanitaire et régulateur, avec augmentation de 30 mn de pouvoir d'achat, La ville d'Ecully s'organise sur le marché de la prostitution....




ea

Le discret cumul de Jean-Yves Le Drian

Le Breton restera ministre de la Défense et déléguera sa présidence de la région Bretagne à un adjoint loyal. Pour la reprendre, quand il quittera le gouvernement. (source : L'Obs) J'ai entendu à la radio que le ministre assurerait sa présidence de région...




ea

Formal Measures of Intelligence!

Above 50?..IQs are important to observe your mental development!




ea

Un rapport d'un groupe de r�flexion chinois "Un nouveau mod�le pour le progr�s humain et son importance mondiale" d�voil� au Br�sil

Le Forum des m�dias et des groupes de r�flexion du Sud global s'est tenu lundi et mardi � Sao Paulo, et un rapport intitul� "Un nouveau mod�le pour le progr�s humain et son importance mondiale" a �t� diffus� � cette occasion. Il fournit une...




ea

La Chine s'appr�te � lancer le vaisseau cargo Tianzhou-8

La combinaison du vaisseau cargo Tianzhou-8 et d'une fus�e porteuse Longue Mache-7 Y9 a �t� verticalement transf�r�e mercredi vers la zone de lancement. Le vaisseau spatial sera lanc� � un moment opportun dans un proche avenir, selon l'Agence des...




ea

La modernisation chinoise favorise un nouveau mod�le de d�veloppement humain

Un rapport conjoint intitul� "Un nouveau mod�le pour le progr�s humain et son importance mondiale" a �t� publi� lors du Forum des m�dias et des groupes de r�flexion du Sud global qui s'est tenu lundi � Sao Paulo, au Br�sil. R�dig� par des groupes...




ea

Le commerce de la Chine avec les autres �conomies de l'APEC a atteint un niveau record entre janvier et octobre

Le commerce de la Chine avec les autres �conomies de l'APEC a atteint un niveau record de 21.270 milliards de yuans (environ 2.950 milliards de dollars) au cours des dix premiers mois de 2024, selon les donn�es publi�es mercredi par l'Administration...




ea

Hostname/IP Address Resolution Utility Released

A new utility that resolves an IP address from a given hostname (and vice versa) has just been released.




ea

Excel Spreadsheet Unlocking Utility Released

Sometimes Excel spreadsheets contain locked sheets that cannot be updated without entering a password. This free online utility removes the password protection from any Excel spreadsheet.




ea

Unlocking Excel Spreadsheets With JExcelApi

With a little bit of programming expertise and the help of a Java library called JExcelApi, we can fairly easily unlock an Excel spreadsheet. This article explains how.




ea

Adding "Maven-Like" Dependency Management To NetBeans Projects with Ivy

When working with Maven projects from NetBeans, some very nice NetBeans features are lost, such as the ability to use the Matisse GUI Builder, developing JSF web applications visually and automatically generating JPA entities from existing database schemas. In this article we explain how to keep all the benefits of Maven without losing NetBeans functionality by integrating Ivy into NetBeans projeccts.




ea

Reasons To Use Linux

Still hesitating to make the move? In this article we list several compelling reasons to migrate to Linux.






ea

Nieuw voetbalgear nodig?

Voetbal: het is een sport waar we ons allemaal een beetje mee verbonden voelen en de sport heeft dan ook ...... Lees verder: Nieuw voetbalgear nodig?




ea

Digg It! Digg Headlines 24/7




ea

New Release - Land for Sale in Burton-on-Trent, Staffordshire

Pasture and Potential Investment land for sale. This attractive parcel of land totals over 62 acres and has the unique benefit of river frontage.




ea

New Release - Land for Sale in Towcester, Northamptonshire

Around 15 acres of flat land for sale, the land is available as a whole or in lots and benefits from strong investment potential due to the proximity of nearby developments.




ea

New Release - Land for Sale in Ilkeston, Derbyshire

The land forms an excellent block of highly productive arable land totalling over 15 acres. It is perfectly placed between Derby and Nottingham, with excellent transport links and just 3 miles from Ilkeston town centre.




ea

New Release - Land for Sale in Melton Mowbray, Leicestershire

A well managed block of agricultural land for sale available freehold as a whole or in lots suitable for paddock conversion. The land benefits from extensive road frontage and superb track access.




ea

New Release - Land for Sale in Solihull, Birmingham

A rare and desirable opportunity to purchase a block of strategic land just 8 miles from Birmingham City Centre. Totalling over 14 acres the land is available freehold as a whole or lots, with strong investment potential.




ea

New Release - Land for Sale in Stokenchurch

An opportunity to buy land for sale in affluent Buckinghamshire with superb access next to land that has recently been reclassified and granted planning permission.The land is available freehold as a whole or in lots.




ea

New Release - Land for Sale in Hemel Hempstead

Just two lots remaining at this land for sale just 24 miles from the City of London within the affluent county of Hertfordshire. This lush grazing land is available freehold and is suitable for paddock conversion.




ea

New Release - Land for Sale in Buckinghamshire, Water End

Just one lot of lush grazing land for sale in Buckinghamshire, one of the most affluent counties in the UK. The land measures approx 2.5 acres and with superb access, would be ideal for paddock conversion.






ea

Are older releases of the database really unsupported?

articles: 

I see posts on Oracle related forums about various releases (anything that isn't 11.x or 12.x) being "unsupported". This is wrong. Of course you should upgrade any 9i or 10g databases, but you don't have to.

Oracle Corporation's lifetime support policy is documented here,
Lifetime Support Policy
take a look, and you'll see that release 10.2 was in premier support until end July 2010 when it went into extended support. At end July 2013, it goes into sustaining support. Sustaining support will continue indefinitely. Even release 8.1.7 will have sustaining support indefinitely.
So what is sustaining support? That is documented here,
Lifetime support benefits
To summarize, extended support gives you everything you are likely to need. What you do not get is certification against new Oracle products or new third party products (principally, operating systems). But does that matter? I don't think so. For example, release 11.2.0.3 (still in premier support) is not certified against Windows 8, but it works fine.
Sustaining support has a more significant problem: no more patches. Not even patches for security holes, or changes in regulatory requirements. The security patch issue may of course be serious, but regulatory issues are unlikely to matter (this is a database, not a tax management system.) Think about it: 10g has been around for many years. It is pretty well de-bugged by now. If you hit a problem with no work around, you are pretty unlucky. Sustaining support gives you access to technical support, available patches, software, and documentation. That is all most sites will ever need.
Right now, I am working on a 9.2.0.8 database. It cannot be upgraded because the application software is written by a company that does not permit a database upgrade. Why not? Well, the reason may be commercial: they have a replacement product that is supported on newer databases. But that is nothing to do with me. The database works, the software works. Making it work better is a challenge - but that is what a DBA is paid to do. Don't just write it off as "unsupported".
Of course I am not suggesting that users should not upgrade to current releases - but upgrades are a huge project, and can have major implications. Running out dated software is silly, unless you have an irrefutable reason for so doing. The lack of security patches make you vulnerable to data loss. The lack of regulatory patches may make it illegal. The lack of newer facilities will be restricting the utility of the system. You may be losing money by not taking of advantage of changes of newer technology that can better exploit your hardware.
If anyone is looking for consulting support to upgrade their database - my boss will be happy to give you a quote. But I won't refuse to support you in the meantime.
--
John Watson
Oracle Certified Master DBA
http://skillbuilders.com




ea

SQL*Plus error logging – New feature release 11.1

articles: 

One of the most important things that a developer does apart from just code development is, debugging. Isn’t it? Yes, debugging the code to fix the errors that are raised. But, in order to actually debug, we need to first capture them somewhere. As of now, any application has it’s own user defined error logging table(s).

Imagine, if the tool is rich enough to automatically capture the errors. It is very much possible now with the new SQL*PLus release 11.1

A lot of times developers complain that they do not have privilege to create tables and thus they cannot log the errors in a user defined error logging table. In such cases, it’s a really helpful feature, at least during the unit testing of the code.

I made a small demonstration in SCOTT schema using the default error log table SPERRORLOG, hope this step by step demo helps to understand easily :

NOTE : SQL*Plus error logging is set OFF by default. So, you need to “set errorlogging on” to use the SPERRORLOG table.

SP2 Error

Copyright (c) 1982, 2010, Oracle.  All rights reserved.

Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL> desc sperrorlog;
 Name                                      Null?    Type
 ----------------------------------------- -------- ----------------------------

 USERNAME                                           VARCHAR2(256)
 TIMESTAMP                                          TIMESTAMP(6)
 SCRIPT                                             VARCHAR2(1024)
 IDENTIFIER                                         VARCHAR2(256)
 MESSAGE                                            CLOB
 STATEMENT                                          CLOB

SQL> truncate table sperrorlog;

Table truncated.

SQL> set errorlogging on;
SQL> selct * from dual;
SP2-0734: unknown command beginning "selct * fr..." - rest of line ignored.
SQL> select timestamp, username, script, statement, message from sperrorlog;

TIMESTAMP
---------------------------------------------------------------------------
USERNAME
--------------------------------------------------------------------------------

SCRIPT
--------------------------------------------------------------------------------

STATEMENT
--------------------------------------------------------------------------------

MESSAGE
--------------------------------------------------------------------------------

11-SEP-13 01.27.29.000000 AM
SCOTT


TIMESTAMP
---------------------------------------------------------------------------
USERNAME
--------------------------------------------------------------------------------

SCRIPT
--------------------------------------------------------------------------------

STATEMENT
--------------------------------------------------------------------------------

MESSAGE
--------------------------------------------------------------------------------

selct * from dual;
SP2-0734: unknown command beginning "selct * fr..." - rest of line ignored.

ORA Error

SQL> truncate table sperrorlog;

Table truncated.

SQL> select * from dula;
select * from dula
              *
ERROR at line 1:
ORA-00942: table or view does not exist

SQL> select timestamp, username, script, statement, message from sperrorlog;

TIMESTAMP
---------------------------------------------------------------------------
USERNAME
--------------------------------------------------------------------------------

SCRIPT
--------------------------------------------------------------------------------

STATEMENT
--------------------------------------------------------------------------------

MESSAGE
--------------------------------------------------------------------------------

11-SEP-13 01.36.08.000000 AM
SCOTT


TIMESTAMP
---------------------------------------------------------------------------
USERNAME
--------------------------------------------------------------------------------

SCRIPT
--------------------------------------------------------------------------------

STATEMENT
--------------------------------------------------------------------------------

MESSAGE
--------------------------------------------------------------------------------

select * from dula
ORA-00942: table or view does not exist

Like shown above, you can capture PLS errors too.

If you want to execute it through scripts, you can do it like this, and later spool the errors into a file. I kept these three lines in the sperrorlog_test.sql file -

truncate table sperrorlog;
selct * from dual;
select * from dula;

SQL> @D:sperrorlog_test.sql;

Table truncated.

SP2-0734: unknown command beginning "selct * fr..." - rest of line ignored.
select * from dula
              *
ERROR at line 1:
ORA-00942: table or view does not exist


SQL> select TIMESTAMP, SCRIPT, STATEMENT, MESSAGE from sperrorlog;

TIMESTAMP
---------------------------------------------------------------------------
SCRIPT
--------------------------------------------------------------------------------

STATEMENT
--------------------------------------------------------------------------------

MESSAGE
--------------------------------------------------------------------------------

11-SEP-13 01.50.17.000000 AM

D:sperrorlog_test.sql;
SP2-0734: unknown command beginning "D:sperror..." - rest of line ignored.


TIMESTAMP
---------------------------------------------------------------------------
SCRIPT
--------------------------------------------------------------------------------

STATEMENT
--------------------------------------------------------------------------------

MESSAGE
--------------------------------------------------------------------------------

11-SEP-13 01.50.27.000000 AM
D:sperrorlog_test.sql
selct * from dual;
SP2-0734: unknown command beginning "selct * fr..." - rest of line ignored.


TIMESTAMP
---------------------------------------------------------------------------
SCRIPT
--------------------------------------------------------------------------------

STATEMENT
--------------------------------------------------------------------------------

MESSAGE
--------------------------------------------------------------------------------

11-SEP-13 01.50.27.000000 AM
D:sperrorlog_test.sql
select * from dula
ORA-00942: table or view does not exist

SQL>

Check Oracle documentation on SPERRORLOG.

In addition to above, if you want to be particularly specific about each session’s error to be spooled into a file you could do this -

SQL> set errorlogging on identifier my_session_identifier

Above mentioned IDENTIFIER keyword becomes a column in SPERRORLOG table. It would get populated with the string value “my_session_identifier”. Now you just need to do this -
SQL> select timestamp, username, script, statement, message
2 from sperrorlog
3 where identifier = 'my_session_identifier';

To spool the session specific errors into a file, just do this -

SQL> spool error.log
SQL> select timestamp, username, script, statement, message
2 from sperrorlog
3 where identifier = 'my_session_identifier';
SQL> spool off