Home » Developer & Programmer » Forms » Sql Loader command can be used in Forms (Oracle 9i, Forms 6i)
Sql Loader command can be used in Forms [message #347179] Thu, 11 September 2008 00:02 Go to next message
mm_kanish05
Messages: 487
Registered: January 2007
Location: Chennai
Senior Member

Hi
Server utility commands can be used in Form /reports.

My presend work.

1. I am receiving the attendance as (*.txt)file which all collected via proximity reader.

2. That we are loading through Sql Loader. The below are fixed length data. emplcode (5),dateofattend(10) and status of attend(2) and forgot about 0.

0001101/08/2008XX  0
0001102/08/2008XX  0
0001103/08/2008TT  0
0001104/08/2008XC  0
0001105/08/2008WW  0
0001106/08/2008XX  0
0001107/08/2008XX  0
0001108/08/2008XX  0
0001109/08/2008XX  0
0001110/08/2008CC  0
0001111/08/2008XX  0


My requiredment is instead we(System people) are loading the file, is there any possible to load the file using through Forms (bcoz the end user can do through that.)

Please share If any better way through Forms.

Thanks.

Wbr
Kanish
Re: Sql Loader command can be used in Forms [message #347191 is a reply to message #347179] Thu, 11 September 2008 00:49 Go to previous messageGo to next message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT Australia
Senior Member
Account Moderator
Read the file using 'text_io' or 'utl_file'.

David
Re: Sql Loader command can be used in Forms [message #347241 is a reply to message #347179] Thu, 11 September 2008 03:02 Go to previous messageGo to next message
mm_kanish05
Messages: 487
Registered: January 2007
Location: Chennai
Senior Member

Thanks for answer david

Can Get the prober link for both to read about.


wbr
kanish
Re: Sql Loader command can be used in Forms [message #347243 is a reply to message #347241] Thu, 11 September 2008 03:03 Go to previous messageGo to next message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT Australia
Senior Member
Account Moderator
Search this forum, Oracle website, google it. Look at the list of objects at the bottom of the Forms Builder and in ALL_SOURCE in the database.

David
Re: Sql Loader command can be used in Forms [message #347301 is a reply to message #347179] Thu, 11 September 2008 04:48 Go to previous messageGo to next message
mm_kanish05
Messages: 487
Registered: January 2007
Location: Chennai
Senior Member

whether it is natively availble if not how i check it.

Thank

wbr
kanish
Re: Sql Loader command can be used in Forms [message #347477 is a reply to message #347301] Thu, 11 September 2008 18:13 Go to previous messageGo to next message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT Australia
Senior Member
Account Moderator
Muthu,

If it isn't "natively availble" then you sure as hell won't be able to use it!

David
Re: Sql Loader command can be used in Forms [message #347500 is a reply to message #347179] Thu, 11 September 2008 22:09 Go to previous messageGo to next message
mm_kanish05
Messages: 487
Registered: January 2007
Location: Chennai
Senior Member

Sorry to ask you the above query why because

im getting the following error:
when i compile the below code

PROCEDURE Loadfile(Filename in Varchar2) IS
     Myfile Client_Text_IO.Filetype;
     Cur_Rec Number;
BEGIN
    Null;
END;



Error identifier Client_Text_IO.Filetype must be declare


So that im asking

kanish

[Updated on: Thu, 11 September 2008 22:09]

Report message to a moderator

Re: Sql Loader command can be used in Forms [message #347932 is a reply to message #347500] Mon, 15 September 2008 02:03 Go to previous messageGo to next message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT Australia
Senior Member
Account Moderator
Try 'file_type'.

David
Re: Sql Loader command can be used in Forms [message #349146 is a reply to message #347932] Fri, 19 September 2008 02:06 Go to previous messageGo to next message
ka_wish
Messages: 85
Registered: October 2007
Location: karachi
Member

i am developed attendance System in oracle developer
perfectly run im happy secess to my project.
if you are require attendace barcode system then


contact me rizwanadmani@gmail.com
thanks
Rizwan Admani
Re: Sql Loader command can be used in Forms [message #349294 is a reply to message #349146] Fri, 19 September 2008 13:16 Go to previous messageGo to next message
subba99
Messages: 31
Registered: September 2008
Member
hi admani
can u send the attendence system to subbu.alg@gmail.com



regards

subba
Re: Sql Loader command can be used in Forms [message #349391 is a reply to message #349146] Sun, 21 September 2008 02:32 Go to previous messageGo to next message
salwa
Messages: 76
Registered: December 2007
Member
can u send the attendence system to titu_3038@yahoo.com
Re: Sql Loader command can be used in Forms [message #349397 is a reply to message #349391] Sun, 21 September 2008 07:01 Go to previous message
Littlefoot
Messages: 20901
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Please, STOP turning this thread into another "me too" one.

Rizwan has clearly said
Quote:
contact me
giving his e-mail address. It means that all of you, who need the solution, should send him an e-mail in order to arrange code transfer.

Once again: no more "send me solution" messages, please.
Previous Topic: LOV EXECUTION
Next Topic: clearing item which have multi records
Goto Forum:
  


Current Time: Fri Dec 09 15:52:11 CST 2016

Total time taken to generate the page: 0.20056 seconds