amar
New User
Nov 13, 2007, 10:06 AM
Post #1 of 1
(3352 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.
|
MAIN
SEARCH
WHO'S 
LOG 