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:
I have a file containing sql statements how could i load that file into oracle database.

 



amar
New User

Nov 13, 2007, 10:06 AM

Post #1 of 1 (3979 views)
I have a file containing sql statements how could i load that file into oracle database. Can't Post

my file is like this
Create table xyz (
abc (VARCHAR2(64)) NOT NULL
def (VARCHAR2(150)) NOT NULL
CONSTRAINT xyz_pk PRIMARY KEY (acb));
insert into xyz ('a:100','sa00230');
insert into xyz('a:1000','sa04514');
insert into xyz ('a:10000','a04010');
insert into xyz ('a:10000','a04012');

i want to call the file containg sql statements from perl script<br/>
if i do it individually it worked <br/>

#!/usr/bin/perl<br/>

use DBI;<br/>
$user = "xyz";<br/>
$passwd = "somethingortheother";<br/>
$dbh = DBI-> connect("dbi:Oracle:host=15161.1m1;sid=anaa;port=1521", $user, $passwd)<br/>
or die "Couldn't connect to database: " . DBI-> errstr;
$c = "insert into xyz values ('a100','sa00230')"; <br/>
$dbh->do($c);<br/>

but if could not open a file and do 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