warn ?!
From: Jayakumar Rajagopal (JRajagopal_at_eagleinvsys.com)
Date: 03/26/04
- Next message: Alex A.: "Show/download file from a non public folder"
- Previous message: R. Joseph Newton: "Re: Hash Help Needed !"
- Next in thread: Alok Bhatt: "Re: warn ?!"
- Reply: Alok Bhatt: "Re: warn ?!"
- Maybe reply: R. Joseph Newton: "Re: warn ?!"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
Date: Thu, 25 Mar 2004 22:16:23 -0500 To: <beginners@perl.org>
Hi,
In my program , $sth->execute fails since oracle tables already present. It is very natural. But the waring message output line 37 is different(just behaves as print) from same kind of message at line 57. Any suggestions please..
regards,
Jay
regression Testing table( default : reg_test_cols) name :
Not able to create reg_test_cols <?????? ***** this output is not similar as line 57 *** >
discrepancy report table ( default : disc_table) name :
Not able to create disc_table
at /tmp/selfextract.XXXXXX/install line 57, <> chunk 5.
26 $query=qq { create table reg_test_cols
27 ( tabname varchar2(40),
28 colname varchar2(40),
29 iskey varchar2(1),
30 tocomp varchar2(1),
31 primary key (tabname,colname) )
32 };
33
34 $sth=$dbh->prepare($query)|| warn " $DBI::errstr \n";
35 unless ($sth->execute() )
36 {
37 warn " Not able to create reg_test_cols \n" ;
38 }
39 else
40 {
41 print " Successfully created table reg_test_cols \n";
42 }
43
44
45
46 $query=qq { create table disc_table
47 ( tabname varchar2(40),
48 querycols varchar2(2000),
49 cond varchar2(2000),
50 rerun varchar2(1),
51 seq number(4),
52 primary key (tabname,cond,seq) )
53 };
54 $sth=$dbh->prepare($query) || warn " $DBI::errstr\n ";
55 unless ($sth->execute() )
56 {
57 warn " Not able to create disc_table\n " ;
58 }
- Next message: Alex A.: "Show/download file from a non public folder"
- Previous message: R. Joseph Newton: "Re: Hash Help Needed !"
- Next in thread: Alok Bhatt: "Re: warn ?!"
- Reply: Alok Bhatt: "Re: warn ?!"
- Maybe reply: R. Joseph Newton: "Re: warn ?!"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]