Date: Tue, 30 Mar 2004 10:28:13 -0500
To: <dbi-users@perl.org>
I am tasked to develop a GUI web-base HTML using DBI and DBD::Oracle for
uses to insert, update, delete data from database. My question is how
do I bind actual data from database to let users update it? Some
example is really appreciated.
RE: fetchrow_array performance ... I agree - set RasieError.... it is impossible to tell what is going on in the database without a 10046 trace. ... You aren't error checking your dbi statements - do you have RaiseError ... sender of the delivery error by replying to this message, or notify us by ... (perl.dbi.users)
Re: Evaluated "require $database" not found. ...DBI Error 1046: No database selected ... What I have found is that if the spaceare removed as per the correct syntax, then the DBI_errorhandler will trap and report a connection failure if a non-existent database is specified, as per this example: ... This requires that you first have an installation of mysql setup on a host ... (perl.dbi.users)
Re: Cant call method "prepare" on an undefined value ... Somehow you managed to have an undefined value instead of a DBI database handle in front of ->prepare, which is burried deep inside Oraperl.pm. ...Oracle HTTP Server at Server B. Both server are Solaris server. ... I have installed DBI and DBD into Server B and setup the oraperl in my perl script.... (perl.dbi.users)
RE: fetchrow_array performance ... takes a few seconds to return the rows that makes your selection... Not sure how big your database is but for anything other than ... This will create a trace file in the ... You aren't error checking your dbi statements - do you have RaiseError ... (perl.dbi.users)
