Recent content by RogersJ

Old environment: Oracle 9.2.0.5 Database character set US7ASCII Crystal Reports 7 & 8.5 New environment: Oracle 10.2.0.2 Database character set UTF8 (nls_length_semantics = char) Crystal Reports 7 & 8.5 I'm in the process of upgrading database versions from 9.2.0.5 to 10.2.0.2. Along with the...

I found my problem. Immediately prior to the if statement I had an insert into a table that had action declared as a varchar2(1). Two in to one doesn't go. I didn't have an exception section defined, so I wasn't seeing the true error. Thanks.

I am puzzled. When I change the value passed to my package.procedure from a single character to two characters the trigger calling the package fails. I have an after insert trigger calling ins_support('I') - this works, when you change it to ins_support('ID') it doesn't work...

I'm reporting out on the contents of the aud$ table. The returncode column will contain either a failure code or 0 for success. How do I determine which message file to interogate for the error message text ? Specifically the return code 20500, which was generated by an update statement...

I have an Oracle 9.2.0.5 database on HPUX-11.0 When the target database is open I can connect to it using RMAN and sqlplus. Now that I want to perform a recovery of the control file the database is in nomount mode. I can still connect with sqlplus, but when I connect using RMAN I get...

With scripts that connect to the database, I use externally identified users. Restricting access to objects within the database. Resolution to my problem is: my $dbh = DBI->connect("dbi:Oracle:", "/ as sysdba", " ", {PrintError => 0, AutoCommit => 0, ora_session_mode => 2} )...

I've just upgraded my Oracle database from 8.0.6.3 to 9.2.0.5 This connection used to work with Oracle 8 but doesn't work with 9. my $dbh = DBI->connect "dbi:Oracle:", "internal", " ", {PrintError => 0, AutoCommit => 0, ora_session_mode => 2} ) ; The user...

This problem is occuring in an 8.1.7.4 database running on HPUX 11.0 I recently patched the Oracle software to meet security alert #68. This is the error when running a full export with the following parameters full=y compress=n direct=y consistent=y . about to export XXXXX's tables via...

Resolution: DBI->connect("dbi:Oracle:", '', '', { PrintError=>0, RaiseError =>0, ora_session_mode => 2} )

Sript is now using DBI. I get audited, and I am required not to have usernames and passwords specified in scripts. I know that I could put a table in one of the databases containing the connect strings, userids and passwords, use a shell script to get the data then pass it to the perl script...

I have a system requirement that I can't have hard coded userids and passwords. I have a unix user, in the DBA group, that has an Oracle userid also, and is a SYSDBA. #!/opt/perl/bin/perl # use Oraperl; $lda = ora_login("my_database_name", "internal", " ", {...