OraFAQ Forum: Forms » Sql Loader command can be used in Forms

Home » Developer & Programmer » Forms » Sql Loader command can be used in Forms (Oracle 9i, Forms 6i)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Sql Loader command can be used in Forms [message #347179]

Thu, 11 September 2008 00:02

mm_kanish05
Messages: 493
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

Report message to a moderator

Re: Sql Loader command can be used in Forms [message #347191 is a reply to message #347179]

Thu, 11 September 2008 00:49

djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia

Senior Member
Account Moderator

Read the file using 'text_io' or 'utl_file'.

David

Report message to a moderator

Re: Sql Loader command can be used in Forms [message #347241 is a reply to message #347179]

Thu, 11 September 2008 03:02

mm_kanish05
Messages: 493
Registered: January 2007
Location: Chennai

Senior Member

Thanks for answer david

Can Get the prober link for both to read about.

wbr
kanish

Report message to a moderator

Re: Sql Loader command can be used in Forms [message #347243 is a reply to message #347241]

Thu, 11 September 2008 03:03

djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS 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

Report message to a moderator

Re: Sql Loader command can be used in Forms [message #347301 is a reply to message #347179]

Thu, 11 September 2008 04:48

mm_kanish05
Messages: 493
Registered: January 2007
Location: Chennai

Senior Member

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

Thank

wbr
kanish

Report message to a moderator

Re: Sql Loader command can be used in Forms [message #347477 is a reply to message #347301]

Thu, 11 September 2008 18:13

djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS 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

Report message to a moderator

Re: Sql Loader command can be used in Forms [message #347500 is a reply to message #347179]

Thu, 11 September 2008 22:09

mm_kanish05
Messages: 493
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

djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia

Senior Member
Account Moderator

Try 'file_type'.

David

Report message to a moderator

Re: Sql Loader command can be used in Forms [message #349146 is a reply to message #347932]

Fri, 19 September 2008 02:06

ka_wish
Messages: 87
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

Report message to a moderator

Re: Sql Loader command can be used in Forms [message #349294 is a reply to message #349146]

Fri, 19 September 2008 13:16

subba99
Messages: 31
Registered: September 2008

Member

hi admani
can u send the attendence system to subbu.alg@gmail.com

regards

subba

Report message to a moderator

Re: Sql Loader command can be used in Forms [message #349391 is a reply to message #349146]

Sun, 21 September 2008 02:32

salwa
Messages: 76
Registered: December 2007

Member

can u send the attendence system to titu_3038@yahoo.com

Report message to a moderator

Re: Sql Loader command can be used in Forms [message #349397 is a reply to message #349391]

Sun, 21 September 2008 07:01

Littlefoot
Messages: 21826
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.

Report message to a moderator

Previous Topic:	LOV EXECUTION
Next Topic:	clearing item which have multi records

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Jun 14 10:35:12 CDT 2026