Home » SQL & PL/SQL » SQL & PL/SQL » How to load a .raw file using a procedure?? (Oracle 9i, Developer 6i and Win 2000)
How to load a .raw file using a procedure?? [message #359988] Wed, 19 November 2008 02:39 Go to next message
mahatab
Messages: 98
Registered: January 2008
Location: Dhaka
Member

Dear All,
I am working on a system which produced a daily basis .raw file which contains all the information needed for daily attendance system. Now i can open the .raw file in access(as its not a image file) but need to load in oracle 9i using any kind of procedures which will work the latest .raw file generated by the Existing system. Please someone help me. I will be grateful to you....
Re: How to load a .raw file using a procedure?? [message #359990 is a reply to message #359988] Wed, 19 November 2008 02:45 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
use BLOB and SQL*Loader, for instance.

Regards
Michel
Re: How to load a .raw file using a procedure?? [message #360059 is a reply to message #359988] Wed, 19 November 2008 07:09 Go to previous messageGo to next message
mail2das.ashok
Messages: 10
Registered: May 2008
Junior Member
use sql* loader
Re: How to load a .raw file using a procedure?? [message #360067 is a reply to message #360059] Wed, 19 November 2008 07:47 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Thanks for confirming what I said about 5 hours before.

Regards
Michel
Re: How to load a .raw file using a procedure?? [message #360160 is a reply to message #359988] Wed, 19 November 2008 22:23 Go to previous messageGo to next message
mahatab
Messages: 98
Registered: January 2008
Location: Dhaka
Member

Dear Michel,
Sorry for my late responds. I was Sick. By the way I don't have the SQL*Loader and hence can't work on it. So is there any alternative option available to solve the problem? For your better understanding i am attaching the .raw file which you can open using notepad. So anyone can you please help me regarding this matter. Its basically a .raw file but there was no option to upload such file extension. The name of the file changes everyday according to the system date and created in a specific folder along with the current date attendance data, which i need to load everyday with some auto loading scheduler.


Best Regards,
Mahatab
  • Attachment: raw file.jpg
    (Size: 64.73KB, Downloaded 93 times)
Re: How to load a .raw file using a procedure?? [message #360164 is a reply to message #360160] Wed, 19 November 2008 23:05 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Open an image in notepad?

Alternative is external table but you will say you have no access to database server.
Anyway, if you have to do something you must have access to the tools that allow you to do it. Ask the relevant persons.

Regards
Michel
Re: How to load a .raw file using a procedure?? [message #360168 is a reply to message #359988] Wed, 19 November 2008 23:34 Go to previous messageGo to next message
mahatab
Messages: 98
Registered: January 2008
Location: Dhaka
Member

Yes I do have the access of the database.Now please tell me what i have to do with specific demonstration, if you could kindly provide me.. Waiting for your reply
Re: How to load a .raw file using a procedure?? [message #360196 is a reply to message #360168] Thu, 20 November 2008 00:59 Go to previous message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Database Utilities
Part II SQL*Loader

external table

Database Application Developer's Guide - Large Objects

Regards
Michel
Previous Topic: Can't Create Index With An If Statement
Next Topic: Connect by not looping
Goto Forum:
  


Current Time: Sun Dec 04 02:36:51 CST 2016

Total time taken to generate the page: 0.26914 seconds