OraFAQ Forum: Forms » how to call script inside form!!!

Home » Developer & Programmer » Forms » how to call script inside form!!!

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

how to call script inside form!!! [message #279182]

Wed, 07 November 2007 04:51

sh_eng
Messages: 15
Registered: May 2006

Junior Member

hello
I'm using developer 10g,
i make a script and i call it from the sql @script_name it works sucessfully,
now i want to do this call from a button (when_button_pressed) inside a form instead of the sql , so how to do this??

Thanks in advance.

Report message to a moderator

Re: how to call script inside form!!! [message #279201 is a reply to message #279182]

Wed, 07 November 2007 05:31

Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

Using the HOST built-in.

Report message to a moderator

Re: how to call script inside form!!! [message #279213 is a reply to message #279201]

Wed, 07 November 2007 06:34

sh_eng
Messages: 15
Registered: May 2006

Junior Member

hello
Thanks For reply, but i try host('script_name'), it show the script but no execute, so how can i execute it??

Thanks alot

Report message to a moderator

Re: how to call script inside form!!! [message #279223 is a reply to message #279213]

Wed, 07 November 2007 06:59

Maaher
Messages: 7065
Registered: December 2001

Senior Member

No, you should use host to invoke SQL*Plus.

MHE

Report message to a moderator

Re: how to call script inside form!!! [message #279229 is a reply to message #279223]

Wed, 07 November 2007 07:35

sh_eng
Messages: 15
Registered: May 2006

Junior Member

hello
thanks again for your reply,
but i still can't do this
would you plz send me steps of how to invoke sql and how to excute the script in it.

Thanks.

Report message to a moderator

Re: how to call script inside form!!! [message #279232 is a reply to message #279229]

Wed, 07 November 2007 07:40

vamsi kasina
Messages: 2112
Registered: October 2003
Location: Cincinnati, OH

Senior Member

Quote:

would you plz send me steps of how to invoke sql and how to excute the script in it

Would you please post the steps, which you have done till now? (I mean the code, which you have written)

By
Vamsi

Report message to a moderator

Re: how to call script inside form!!! [message #279330 is a reply to message #279232]

Wed, 07 November 2007 17:36

jesliej
Messages: 4
Registered: July 2006
Location: Longview, WA

Junior Member

Hi

What is your platform Windows or Unix?

I use UNIX and this can be done by writing a UNIX shell script

1. Shell script will connect to oracle
2. The Sql script will be executed

In windows you could try the same by using batch files

Thanks
Simpson

Report message to a moderator

Re: how to call script inside form!!! [message #279373 is a reply to message #279330]

Thu, 08 November 2007 00:34

Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

I'm afraid you missed the point - we are talking about calling a SQL file from a form, not command prompt.

Report message to a moderator

Re: how to call script inside form!!! [message #279393 is a reply to message #279373]

Thu, 08 November 2007 01:27

Maaher
Messages: 7065
Registered: December 2001

Senior Member

Well, since Forms Builder is not a command line interpreter you cannot invoke the script as such. You'd have to invoke a separate interpreter (like SQL*Plus) and feed the script you want to that tool. A bit like I said before.

But in a 3 tier environment you should be careful. I don't think HOST() executes on the client. The webutil.pll can help you out there.

MHE

Report message to a moderator

Re: how to call script inside form!!! [message #279407 is a reply to message #279393]

Thu, 08 November 2007 02:23

sh_eng
Messages: 15
Registered: May 2006

Junior Member

hello;
i got lost
let me describe my problem again:
i'm using a oracle devloper 10g, i bulit a form , inside it there is a button (when button pressed) i want to paste a code in this trigger to do the following :
-open the sql command prompt
-execute a script (this script saved in my computer ex: c:\script_name)

so how can i do this

hope to find a solution.

Thanks alot.

Report message to a moderator

Re: how to call script inside form!!! [message #279409 is a reply to message #279407]

Thu, 08 November 2007 03:05

Maaher
Messages: 7065
Registered: December 2001

Senior Member

Ok, I'll see whether I see chance to create a small example for you.

MHE

Report message to a moderator

Re: how to call script inside form!!! [message #279434 is a reply to message #279407]

Thu, 08 November 2007 06:23

Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

Would something like this help?

-- WHEN-BUTTON-PRESSED trigger

HOST('sqlplus -s scott/tiger@ora10 @c:\script_name.sql');

Report message to a moderator

Re: how to call script inside form!!! [message #279439 is a reply to message #279434]

Thu, 08 November 2007 07:46

sh_eng
Messages: 15
Registered: May 2006

Junior Member

hiiiii

Thanks alot, it work well.
Thanks again Razz

Report message to a moderator

Previous Topic:	The code work in database not in forms ... why?
Next Topic:	how to generate a tree

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Mar 12 20:57:39 CDT 2025