Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Crystal reports with database character set change to unicode
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...- RogersJ
- Thread
- Replies: 0
- Forum: Business Objects: Crystal Reports 2 Data Access
-
Procedure quits when length of parameter passed changes
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.- RogersJ
- Post #3
- Forum: Oracle: All versions
-
Procedure quits when length of parameter passed changes
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...- RogersJ
- Thread
- Replies: 4
- Forum: Oracle: All versions
-
Returncode value in sys.aud$
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...- RogersJ
- Thread
- Replies: 1
- Forum: Oracle: All versions
-
RMAN - ORA-12154 TNS:could not resolve service name
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...- RogersJ
- Thread
- Replies: 2
- Forum: Oracle: All versions
-
Oracle & DBI connection issue - without password
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} )... -
Oracle & DBI connection issue - without password
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... -
EXP-00008, ORA-01403 errors on full database export
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...- RogersJ
- Thread
- Replies: 0
- Forum: Oracle: All versions
-
Perl connection to Oracle, without supplying a password ?
Resolution: DBI->connect("dbi:Oracle:", '', '', { PrintError=>0, RaiseError =>0, ora_session_mode => 2} ) -
Perl connection to Oracle, without supplying a password ?
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... -
Perl connection to Oracle, without supplying a password ?
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", " ", {...
