Database Reference
In-Depth Information
ROLLBACK due to Oracle error 372: DBD::Oracle::st execute failed: ORA-00372: file 4
cannot be modified at this time
ORA-01110: data file 4: 'F:\ORADATA\TEN\USERS01.DBF' (DBD ERROR: error possibly near
<*> indicator at char 12 in 'INSERT INTO <*>customer(name, phone) VALUES (:name,
:phone)
RETURNING id INTO :id') [for Statement "INSERT INTO customer(name, phone)
VALUES (:name, :phone)
RETURNING id INTO :id" with ParamValues: :name='Ray', :phone='089/4711',
:id=undef] at ./insert_perf4.pl line 106.
As is evident from the preceding output, the DBI provides a lot of information beyond the
ORACLE DBMS error message “ORA-00372: file 4 cannot be modified at this time”. It retrieves
the second error message on the error stack (ORA-01110: data file 4: 'F:\ORADATA\TEN\
USERS01.DBF'), tells us which SQL statement caused the error, the line number in the Perl
source file for locating the statement, which bind variables were in use, and what their values were.
Source Code Depot
Table 22-5 lists this chapter's source files and their functionality.
Table 22-5. Perl DBI Source Code Depot
File Name
Functionality
ORADBB.pm
The Perl module ORADBB.pm is required to run dbb.pl . It contains several Perl
subroutines, which may be reused by any Perl DBI application (e.g., for
connecting with SYSDBA or SYSOPER privileges).
args.pl
Perl program that prints command line arguments on standard output.
dbb.pl
Command line utility capable of executing arbitrary SQL and PL/SQL
statements. Query result column widths are adjusted automatically.
insert_perf4.pl
Perl program that demonstrates exception handling, PL/SQL execution,
bind variables, ROLLBACK , and COMMIT .
os.pl
Perl program that uses operating system authentication to connect.
perl-dbi-test.pl
Perl Program for testing connectivity to an ORACLE DBMS instance.
 
Search WWH ::




Custom Search