Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

I got "ORA-29284: file read error"!

Status
Not open for further replies.
AlexHarley666

AlexHarley666

Programmer
Dec 5, 2002
31
0
0
CL
Hello my friends:

I have the next code:

Var_Archivo Utl_File.File_Type;
Var_Ubicacion VarChar2(100):='/usr/tango/v10/pp/bdpfile/';
Var_Existe Boolean;
Var_Largo_Archivo Number(8);
Var_TamañoBloque Number(8);
Var_Linea VarChar2(10000):=Null;
Var_Largo Number(4):=64;
Var_NombArchivo VarChar2(50):=Null;

...

Begin
...

Var_NombArchivo := 'aaa'
Utl_File.FGetAttr(Var_Ubicacion, Var_NombArchivo, Var_Existe, Var_Largo_Archivo, Var_TamañoBloque);
If Var_Existe Then
Var_Archivo := Utl_File.FOpen(Var_Ubicacion,Var_NombArchivo,'r');
Begin
Utl_File.Get_Line(Var_Archivo,Var_Linea,Var_Largo);
...


I got problems at "Utl_File.Get_Line(Var_Archivo,Var_Linea,Var_Largo)"
with ORA-29284 error, but, only for 1000 bytes or more file size.

Please, I need your help for this problem...

Thanks in advance,

ALEX
 
Status
Not open for further replies.

Similar threads

George L
  • Locked
  • Question
web app not saving "all" records suddenly
Replies
3
Views
173
carp
carp
Livia8
  • Locked
  • Question
Alternative to "locate" command
Replies
0
Views
148
Livia8
Livia8
Livia8
  • Locked
  • Question
SQL script to find number of characters allowed in "Description" column of "AP_INVOIC 2
Replies
5
Views
115
Livia8
Livia8
TheLazyPig
  • Locked
  • Question
Inserting Text Decimal to Table Error
Replies
4
Views
179
carp
carp
Livia8
  • Locked
  • Question
Generate report/output on the basis of "enquiry" responsibilities only 1
Replies
16
Views
96
Livia8
Livia8

Part and Inventory Search

Sponsor

Back
Top