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

  Main Index MAIN
INDEX
Search Posts SEARCH
POSTS
Who's Online WHO'S
ONLINE
Log in LOG
IN

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

 



rajjj
Novice

Aug 11, 2006, 10:25 PM

Post #1 of 3 (2556 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.

thanx..


davorg
Thaumaturge / Moderator

Aug 14, 2006, 4:52 AM

Post #2 of 3 (2551 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
http://www.dave.org.uk/
Get more help at Perl Monks


d1zz13
User

Aug 14, 2006, 5:29 AM

Post #3 of 3 (2548 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

Regards
Rich

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