Re: PERL , DBI , DBD and ORACLE

Be sure you have correctly added a space between the quotes - if no space, it is considered NULL .. If Perl watch out for the quotes...binding a variable with a value that includes a quote ( single will do) can be a little tricky...check it closely..

farooqm_at_mail.com (farooq) wrote:

>Hi,
> We have oracle 8.1.5 running on AIX 4.3.1. I installed PERL 5.6 ,
>DBI 1.20 and DBD-Oracle-1.12. When running a PERL programs, I am
>getting this unusal problem. There is something wrong with this
>combination, as the following message is generated when trying to
>insert :
>
>DBD::Oracle::st execute failed: ORA-01400: cannot insert NULL into
>("SAC"."T_ANNPROG"."SYS_REC_ACTN_CD") (DBD ERROR: OCIStmtExecute) at
>bad8i3.pl line 37.
>ORA-01400: cannot insert NULL into
>("SAC"."T_ANNPROG"."SYS_REC_ACTN_CD") (DBD ERROR: OCIStmtExecute) at
>bad8i3.pl line 37.
>$ pwd
>
>
>I am not sure if this is the right group I am posting to, but the PERL
>guys referred to DB groups. Basically , the error shown above is from
>a PERL program that is trying to insert into a database. The thing it
>is complaining about is a blank space " " that it is considering as a
>NULL. I can make the same insert with a blank space from SQL*PLUS, but
>if I put in a blank space in the insert statement (where the field in
>which I am trying to insert into is NOT NULLABLE), then I get this
>error. Somehow, it is not recognizing the blank space ,and mistaking
>it for a NULL, which souldn't be the case. I have tried a different
>combination of PERL ( and its DBI and DBD). The weird thing is , on a
>Oracle7.3.2 Database running on the same machine, with older version
>of PERL ( and DBI,DBD), the same exact program just runs fine.
>
>Any help ? ANYONE ???
>
>Thanks
>Farooq

-----= Posted via Newsfeeds.Com, Uncensored Usenet News =----- http://www.newsfeeds.com - The #1 Newsgroup Service in the World!  Check out our new Unlimited Server. No Download or Time Limits! -----== Over 80,000 Newsgroups - 19 Different Servers! ==----- Received on Tue Dec 11 2001 - 15:39:10 CST