SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

How to use utl_file.fgetpos

muttleychessJan 22 2007 — edited Jan 22 2007

Hi
I need to read a file and write in other file, but some informations there are in line more below, and I would like go to this lines and go back the original line (row)

 i := utl_file.fgetpos(InFile);

Example

A010000000021532332522 already read
B113132121212121212212 already read
C152326223221212121211 I am here
C231321231212121212122 not read
C562312121212121212222 not read
D312312121313211202232 not read
E322222121212121212121 not read
F21213MY INFORMATION not read AND is my information
G212121212121213523222 not read

I am in First Line C and need to get a information in line F, and go back to Line C,. Without to open other handler

Locked Post

New comments cannot be posted to this locked post.

Locked on Feb 19 2007

Added on Jan 22 2007

5 comments

650 views