Home » Developer & Programmer » Forms » Running PL/SQL script from Developer 2000
Running PL/SQL script from Developer 2000 [message #375403] Thu, 05 October 2000 19:29 Go to next message
Nilesh
Messages: 16
Registered: November 1999
Junior Member
I am trying to run a pl/sql script (.sql file) from within forms builder. I am using forms_ddl(path) but it doesn't work. Does anyone have any ideas as to how I can run the script from developer.
Re: Running PL/SQL script from Developer 2000 [message #375405 is a reply to message #375403] Thu, 05 October 2000 19:34 Go to previous messageGo to next message
Venkatesh Ramamurthi
Messages: 4
Registered: September 2000
Junior Member
One question : Where is the PL/SQL Script residing. If it is a unix box then you can use DBMS_PIPE package - send message, pack message and receive message functions to run the script.
Regards
Re: Running PL/SQL script from Developer 2000 [message #375420 is a reply to message #375405] Wed, 11 October 2000 19:07 Go to previous messageGo to next message
Nilesh
Messages: 16
Registered: November 1999
Junior Member
The file is on my harddrive. My OS is Windows NT and the file is in the temp directory.
Or the file is also on VAX (where the DB is). If anyone can tell me how to run scripts from there.
Thanks
Re: Running PL/SQL script from Developer 2000 [message #375421 is a reply to message #375420] Wed, 11 October 2000 19:26 Go to previous message
Venkatesh Ramamurthi
Messages: 4
Registered: September 2000
Junior Member
1. Copy the contents of the sql file and paste them in a program unit in the form from where you are trying to call the sql file.
2. If you are not on the Unix OS, you can try using host, but you need a driver to drive your sql file. You can use plus33.exe to execute your script. But the output will not appear on the form.
Pls take a look at this and let me.
In any case, please explain in detail what exactly you are trying to do.
chao
venkatesh
Previous Topic: SQL Loader
Next Topic: Simple question on RECORD GROUP creation...
Goto Forum:
  


Current Time: Fri Apr 19 02:32:13 CDT 2024