wood burning stoves 2.0*
The moose likes Oracle/OAS and the fly likes Oracle Stored Procedure Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Products » Oracle/OAS
Bookmark "Oracle Stored Procedure" Watch "Oracle Stored Procedure" New topic
Author

Oracle Stored Procedure

amit prajapati
Greenhorn

Joined: Oct 18, 2011
Posts: 5

Hi,

I have oracle procedure which run every one hour though cron job. But during night time when procedure is executed it do not generate proper data. I am not able to find the exact reason for this

The Procedure generate data in the below format

9938446473,20130822120458,2496,1
8233566279,20130822120525,3080,1
8233175625,20130822120527,2498,1

But in the night, i find some of rows were not generated properly in text file.

67,1


PLSQL PROC :



 
wood burning stoves
 
subject: Oracle Stored Procedure
 
Similar Threads
Is it possible to have a store procedre that has PL/SQL code and can call a java obje
Getting error while reading file by using UTL_FILE
SQLException Cursor Closed
Is it possible to have a store procedre that has PL/SQL code and can call a java obje
Large data file read