OraFAQ Forum: Forms » is it possible to associate a synchronized progress bar to the exporting process? & attaching to

Home » Developer & Programmer » Forms » is it possible to associate a synchronized progress bar to the exporting process? & attaching to

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

is it possible to associate a synchronized progress bar to the exporting process? & attaching to [message #299406]

Mon, 11 February 2008 21:48

amdabd
Messages: 91
Registered: November 2007
Location: My Computer

Member

hi,
-- how can determine what will be the size of the exported data before the exporting process is done ?,
-- and is it possible to associate a synchronized progress bar to the exporting process?
thanks

Report message to a moderator

Re: is it possible to associate a synchronized progress bar to the exporting process? [message #299419 is a reply to message #299406]

Tue, 12 February 2008 00:06

azamkhan
Messages: 557
Registered: August 2005

Senior Member

Count me in for this post also.

If you are using EXPORT utility which is executed on command prompt then I think that progress bar cann't linked with the export b/c the export utility doesn't no return you any value that tell you how many export is done or how many is still left.

Regards,
Azam Khan

Report message to a moderator

Re: is it possible to associate a synchronized progress bar to the exporting process? [message #299681 is a reply to message #299406]

Tue, 12 February 2008 23:32

amdabd
Messages: 91
Registered: November 2007
Location: My Computer

Member

dear Azam Khan
hi,
the export utility is running through a form by using [ host] within a push button

Report message to a moderator

Re: is it possible to associate a synchronized progress bar to the exporting process? [message #299691 is a reply to message #299681]

Tue, 12 February 2008 23:43

azamkhan
Messages: 557
Registered: August 2005

Senior Member

Dear Friend,

I am also running this kind user interface backup style with HOST command in my form. I was also searching for this. But I dont think so that we can synchronize the progress bar b/c the host command doesn't return its status I mean it doesn't tell what it is doing. But we can find that is the command run successfully or not.

If you find out the answer please do let me also know.

Regards,
Azam Khan

Report message to a moderator

Re: is it possible to associate a synchronized progress bar to the exporting process? [message #299948 is a reply to message #299406]

Wed, 13 February 2008 18:35

amdabd
Messages: 91
Registered: November 2007
Location: My Computer

Member

Dear Azam Khan
hi,
I hope I could get the answer ,
A year ago I worked for an organization with multi-branches with Oracle 9i database interface, they used this interface backup style
, the progress bar was nearly synchronized - with time & dump file size.

So, I think it's possible to be implemented upon Oracle10g interface.
thanks

[Updated on: Wed, 13 February 2008 18:36]

Report message to a moderator

Re: is it possible to associate a synchronized progress bar to the exporting process? [message #299976 is a reply to message #299948]

Wed, 13 February 2008 22:45

azamkhan
Messages: 557
Registered: August 2005

Senior Member

Dear Friend,

Thanks for sharing this information. If you get any information about doing this on Developer 6i then please let me know also.

And by the way can you tell me how from EXPORT or IMPORT utility one can get the size of the export file along with time?

Regards,
Azam Khan

Report message to a moderator

attaching tools built in V.Basic ? [message #304396 is a reply to message #299406]

Wed, 05 March 2008 01:10

amdabd
Messages: 91
Registered: November 2007
Location: My Computer

Member

hi,
How can I attaching a tool built in V. Basic to a form ?
thanks

[Updated on: Wed, 05 March 2008 01:11]

Report message to a moderator

Re: attaching tools built in V.Basic ? [message #304469 is a reply to message #304396]

Wed, 05 March 2008 05:56

bbaz
Messages: 138
Registered: April 2007

Senior Member

Quote:

attaching a tool built in V. Basic to a form ?

Do you mean EMBEDDING your VB tool INTO an Oracle Form? If so, I am not sure if this is Doable. I can only suggest TRIGGERING/CALLING the VB tool from Oracle Form using the HOST() command.

Below is a related link that I found on Oracle Forum:

http://forums.oracle.com/forums/thread.jspa?messageID=1934940&#1934940

Hope it helps.

Baz

Report message to a moderator

Re: attaching tools built in V.Basic ? [message #304611 is a reply to message #304396]

Wed, 05 March 2008 17:07

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

Senior Member
Account Moderator

I have no idea how you will do this but it may be helpful to others to know which version of Forms you are using.

David

Report message to a moderator

Re: attaching tools built in V.Basic ? [message #304830 is a reply to message #304396]

Thu, 06 March 2008 18:30

amdabd
Messages: 91
Registered: November 2007
Location: My Computer

Member

hi,
Thanks everybody,
I'm using forms 10g.

...
Host( 'cmd/c start "" "VB.EXE"');
...

actually I need to embed the V.Basic FORM or TOOL on Oracle form
to be as same as PUSHBUTTON or other oracle developer tools

NOT to run the V.B FORM or TOOL in separate process.

thanks again

Report message to a moderator

Re: attaching tools built in V.Basic ? [message #304837 is a reply to message #304830]

Thu, 06 March 2008 19:50

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

Senior Member
Account Moderator

Why?

David

Report message to a moderator

Re: attaching tools built in V.Basic ? [message #305043 is a reply to message #304396]

Fri, 07 March 2008 13:36

amdabd
Messages: 91
Registered: November 2007
Location: My Computer

Member

hi,
I'm trying to get the size of exported dump file during exporting process

previous subscription
-- how can determine what will be the size of the exported data before the exporting process is done ?,
-- and is it possible to associate a synchronized progress bar to the exporting process?

I didn't find my answer in Oracle, I try to get substitutes.

Report message to a moderator

Re: is it possible to associate a synchronized progress bar to the exporting process? [message #306807 is a reply to message #299976]

Sun, 16 March 2008 23:07

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

Senior Member
Account Moderator

Look at http://www.orafaq.com/forum/m/300271/67467/?srch=size+dump#msg_300271

David

Report message to a moderator

Re: attaching tools built in V.Basic ? [message #306808 is a reply to message #305043]

Sun, 16 March 2008 23:10

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

Senior Member
Account Moderator

Look at http://www.orafaq.com/forum/m/300271/67467/?srch=size+dump#msg_300271

David

Report message to a moderator

Re: attaching tools built in V.Basic ? [message #307103 is a reply to message #304396]

Mon, 17 March 2008 18:06

amdabd
Messages: 91
Registered: November 2007
Location: My Computer

Member

dear David
hi,
Thanks for your concern,however, the two topics are belonged to me

My main idea is to make a progress bar on a FORM synchronized with the exporting process ;
I can't find my way within ORACLE so, I'm try using a mix of different tools .

It still useless

& I still trying

Report message to a moderator

Re: is it possible to associate a synchronized progress bar to the exporting process? [message #307105 is a reply to message #306807]

Mon, 17 March 2008 18:10

amdabd
Messages: 91
Registered: November 2007
Location: My Computer

Member

djmartin wrote on Sun, 16 March 2008 23:07

Look at http://www.orafaq.com/forum/m/300271/67467/?srch=size+dump#msg_300271
David

hi, dear
please, follow this
http://www.orafaq.com/forum/?t=msg&th=98418&114860/

Report message to a moderator

Re: attaching tools built in V.Basic ? [message #307467 is a reply to message #307103]

Tue, 18 March 2008 23:41

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

Senior Member
Account Moderator

If you get the 'ESTIMATE_ONLY' information, then run the export via an asynchronous command, your could review the file size and use it to determine the setting to be shown on the progress bar.

David

Report message to a moderator

Re: is it possible to associate a synchronized progress bar to the exporting process? & attachin [message #307591 is a reply to message #299406]

Wed, 19 March 2008 04:06

amdabd
Messages: 91
Registered: November 2007
Location: My Computer

Member

dear david
hi,
I'm using (HOST)command within a PushBottun to export

declare
alrt number;
v_directory  varchar2(200) := 'c:\backup';
path varchar2(100):='back_up'||to_char(sysdate,'dd-mm-yyyy-hh-mi-ss');
v_exp varchar2(200) := 'exp scott/tiger@orcl file = '||v_directory||'\'||path||'.dmp owner=scott grants=yes';
begin 
	host(v_exp);
if form_success then
	set_alert_property('msg',alert_message_text,'Form success');
alrt:=show_alert('msg');
else
message('there are errors in the process');
end if; 
end;

HOST command do not return values, only Boolean - the event is done or not-

host=expdp hr/hr ESTIMATE_ONLY=y NOLOGFILE=y

then how to get the returned value from HOST()
thanks

Report message to a moderator

Re: is it possible to associate a synchronized progress bar to the exporting process? & attachin [message #307766 is a reply to message #307591]

Wed, 19 March 2008 18:09

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

Senior Member
Account Moderator

Direct the output to a flat-file and then read it.

David

Report message to a moderator

Re: is it possible to associate a synchronized progress bar to the exporting process? & attachin [message #308165 is a reply to message #299406]

Fri, 21 March 2008 12:44

amdabd
Messages: 91
Registered: November 2007
Location: My Computer

Member

how & how to load the required estimated value from file to the form
-----------
(I'm sorry, but just end Form Developer Lessons)

[Updated on: Fri, 21 March 2008 12:51]

Report message to a moderator

Re: is it possible to associate a synchronized progress bar to the exporting process? & attachin [message #308912 is a reply to message #308165]

Tue, 25 March 2008 23:05

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

Senior Member
Account Moderator

Look at 'utl_file' and 'text_io' for reading a file from the server.

David

Report message to a moderator

Previous Topic:	array on forms
Next Topic:	steps needed to download from unix to windows desktop

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Mar 10 22:23:02 CDT 2025