Home » Developer & Programmer » Forms » is it possible to associate a synchronized progress bar to the exporting process? & attaching to
is it possible to associate a synchronized progress bar to the exporting process? & attaching to [message #299406] Mon, 11 February 2008 21:48 Go to next message
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
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 Go to previous messageGo to next message
azamkhan
Messages: 548
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
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 Go to previous messageGo to next message
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
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 Go to previous messageGo to next message
azamkhan
Messages: 548
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
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 Go to previous messageGo to next message
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 Go to previous messageGo to next message
azamkhan
Messages: 548
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
attaching tools built in V.Basic ? [message #304396 is a reply to message #299406] Wed, 05 March 2008 01:10 Go to previous messageGo to next message
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 Go to previous messageGo to next message
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
Re: attaching tools built in V.Basic ? [message #304611 is a reply to message #304396] Wed, 05 March 2008 17:07 Go to previous messageGo to next message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT 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
Re: attaching tools built in V.Basic ? [message #304830 is a reply to message #304396] Thu, 06 March 2008 18:30 Go to previous messageGo to next message
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
Re: attaching tools built in V.Basic ? [message #304837 is a reply to message #304830] Thu, 06 March 2008 19:50 Go to previous messageGo to next message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT Australia
Senior Member
Account Moderator
Why?

David
Re: attaching tools built in V.Basic ? [message #305043 is a reply to message #304396] Fri, 07 March 2008 13:36 Go to previous messageGo to next message
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.


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 Go to previous messageGo to next message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT Australia
Senior Member
Account Moderator
Look at http://www.orafaq.com/forum/m/300271/67467/?srch=size+dump#msg_300271

David
Re: attaching tools built in V.Basic ? [message #306808 is a reply to message #305043] Sun, 16 March 2008 23:10 Go to previous messageGo to next message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT Australia
Senior Member
Account Moderator
Look at http://www.orafaq.com/forum/m/300271/67467/?srch=size+dump#msg_300271

David
Re: attaching tools built in V.Basic ? [message #307103 is a reply to message #304396] Mon, 17 March 2008 18:06 Go to previous messageGo to next message
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
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 Go to previous messageGo to next message
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/
Re: attaching tools built in V.Basic ? [message #307467 is a reply to message #307103] Tue, 18 March 2008 23:41 Go to previous messageGo to next message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT 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
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 Go to previous messageGo to next message
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
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 Go to previous messageGo to next message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT Australia
Senior Member
Account Moderator
Direct the output to a flat-file and then read it.

David
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 Go to previous messageGo to next message
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 Go to previous message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT Australia
Senior Member
Account Moderator
Look at 'utl_file' and 'text_io' for reading a file from the server.

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


Current Time: Fri Dec 02 14:29:12 CST 2016

Total time taken to generate the page: 0.26392 seconds