CGI/Perl Guide | Learning Center | Forums | Advertise | Login
Site Search: in

  Main Index MAIN
Search Posts SEARCH
Who's Online WHO'S
Log in LOG

Home: Perl Programming Help: DBI:
how to execute "SQL> @%ORACLE_HOME%\rdbms\admin\cmpdbmig.sql" using perl script



Aug 11, 2006, 10:25 PM

Post #1 of 3 (2955 views)
how to execute "SQL> @%ORACLE_HOME%\rdbms\admin\cmpdbmig.sql" using perl script Can't Post

hi all

thanq for all , u have been very much helpful to me to complete my task.

As im completely new to perl scripting im not having basic idea of perl syntax.

can anybody help me to finish of with this ..

im not getting the syntax to execute the ".sql" file through perl script.

when im executing it in "sql>"prompt im getting it. specifically the following is the file i need to execute

"SQL> @%ORACLE_HOME%\rdbms\admin\cmpdbmig.sql" how to execute it through perl .

any clue will be gr8ly appreciated.


Thaumaturge / Moderator

Aug 14, 2006, 4:52 AM

Post #2 of 3 (2950 views)
Re: [rajjj] how to execute "SQL> @%ORACLE_HOME%\rdbms\admin\cmpdbmig.sql" using perl script [In reply to] Can't Post

If you're that new to Perl programming then you should really spend some time with a good book before leaping into complex projects like this.

You have two basic options. You can either use system to run an sqlplus command to load the file. Or you can use DBI and DBD::Oracle to connect to the database and execute the individual commands that way.

Dave Cross, Perl Hacker, Trainer and Writer
Get more help at Perl Monks


Aug 14, 2006, 5:29 AM

Post #3 of 3 (2947 views)
Re: [davorg] how to execute "SQL> @%ORACLE_HOME%\rdbms\admin\cmpdbmig.sql" using perl script [In reply to] Can't Post

I think I already answered something like this here


If it aint broke then don't try to fix it


Search for (options) Powered by Gossamer Forum v.1.2.0

Web Applications & Managed Hosting Powered by Gossamer Threads
Visit our Mailing List Archives