|
|||||||||
|
|||||||||
| |||||||||
|
|||||||||
|
|||||||||
| |||||||||
|
|
|
| |||||||||
 |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
Dev Shed Forums Sponsor:
|
|
Get inside! Sample the range of functionality easily built with JMSL Library for Time Series Data Analysis, Heat Maps, Portfolio Optimization, Monte Carlo Simulation, Stock Price Charting and more. Download Now! |
|
#1
January 18th, 2005, 09:05 AM
|
|||
|
|||
|
Pro*C Program stops without giving core
Hi,
Just wanted to ask what might be the possible chances of a Pro*C program getting stopped without even giving core dump. In different runs of the program, the last executed statement were different. Given below is a query I have in that Program. EXEC SQL SELECT COUNT(1) INTO :NoOfRecords FROM MASTER_TABLE WHERE E_ID = ltrim(rtrim(:v_Id)); The program in different runs usually stops before some query.The surprising part is it fetches values for some query and then before firing some other query it just stops. It is not creating a table lock also. If anybody has a clue, do help. I am working on Unix env. Thankz in advance. James..
|
|
#2
January 18th, 2005, 04:37 PM
|
|||
|
|||
|
Pro*C will stop when there are Oracle errors. Well-written code will display what the Oracle error was. This is a simple example - check every time you ask Oracle to do anything.
Code:
void dberror(int err, int linenum)
{
fprintf(stderr,"Oracle error %d on line %d\n",err,linenum);
EXEC SQL ROLLBACK WORK RELEASE;
exit(EXIT_FAILURE);
}
#define CKORA { if ( sqlca.sqlcode < 0) dberror(sqlca.sqlcode, __LINE__); }
#define NO_ROWS_FOUND (sqlca.sqlcode==1403)
int my_function(char *v_id)
{
int NoOfREcords=0;
short ind=0;
EXEC SQL
SELECT COUNT(1)
INTO :NoOfRecords :ind
FROM MASTER_TABLE
WHERE E_ID = ltrim(rtrim(:v_Id));
CKORA;
if(NO_ROWS_FOUND)
{
NoOfRecords=0;
}
return NoOfRecords;
}
CKORA will show an Oracle error and then exit the program.
|
|
#3
January 19th, 2005, 03:41 AM
|
|||
|
|||
|
re: proc stops.
hi,
I actually checked the oracle query from backend. It runs fine. and the program doesnt stop at 1 particular place. In different runs, the program stops at different places. kindly help regards James
|
|
| Viewing: Dev Shed Forums > Databases > Oracle Development > Pro*C Program stops without giving core |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
 |
|
|
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
