OraFAQ Forum: Forms » run sql file from from forms

Home » Developer & Programmer » Forms » run sql file from from forms (10g)

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

run sql file from from forms [message #498032]

Tue, 08 March 2011 05:25

muradjuber
Messages: 60
Registered: August 2010

Member

dear all

i want to run sql file by forms

is there command do that

Report message to a moderator

Re: run sql file from from forms [message #498034 is a reply to message #498032]

Tue, 08 March 2011 05:27

cookiemonster
Messages: 13938
Registered: September 2008
Location: Rainy Manchester

Senior Member

Use host to run it via sqlplus?

It'd help if told us what this sql file was supposed to do.

Report message to a moderator

Re: run sql file from from forms [message #498035 is a reply to message #498034]

Tue, 08 March 2011 05:28

muradjuber
Messages: 60
Registered: August 2010

Member

i want to execute sql file on my desktop

and i want to make it by forms not by sql plus

Report message to a moderator

Re: run sql file from from forms [message #498039 is a reply to message #498035]

Tue, 08 March 2011 05:56

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

Senior Member
Account Moderator

Make a stored procedure (based on a SQL file you are talking about) and call the procedure from a form.

Form, itself, is not capable of executing SQL files stored on a disk; it can, though, run them through SQL*Plus (but you don't want to do that. Why not?).

Report message to a moderator

Previous Topic:	Reading and Writing data in a text file.
Next Topic:	Populate List - Dynamically

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Sep 16 13:07:53 CDT 2024