Oracle Help
in [SQL]
|
utl_file.frename against utl_file.fcopy Hi all, I'm facing a strange problem. I'm executing these commands in my Oracle 10.2 Database running on debian linux. This one is working very well: utl_file.frename( src_location => v_source_dir, src_filename => p_s_filename, dest_location => v_destination_dir, dest_filename ... 8 Sep 2006 09:23
im004 oracle odbc error with unprivileged users Hello, i've been searching the web since hours, but i found no real solutions. I'm using Oracle's Client 10.2 on Windows Server 2003. When i connect to a DB over ODBC (Oracle's drivers), i'm getting an error: "im004 microsoft odbc driver manager driver's sqlallochandle on sql_handle_env failed" This happen... 16 Aug 2006 10:31
Oracle 64 bit ODBC dirver I have migrated an application from a windows 32bit platform to Oracle 10Gr2 on a 64bit platform (Windows 2003 server) and am having problems with values returned from the ODBC interface. All numeric values are returned as 0. Any ideas what the problem might be? The platform is a 64bit EMT Windows 2003 server wi... 3 Aug 2006 16:49
Oracle Designer: Connect string Hello world, when I try to make Oracle Designer connect to a database, it will ask for username, password, and some strange "connect string". While I do know the host IP, port number, and SID of the database, I have no idea what the "connect string" must look like. Who can help? Jens ... 18 Jul 2006 05:05
SQLPLus and Linux (Gentoo) - tnsnames problem Hello I've installed oracle-instantclient, oracle-skd and oracle-sqlplus. everything works fine, except tnsnames... a can connect to remote database using: sqlplus xx/xx@"(description=(address=(host=10.3.1.159)(protocol=tcp)(port=1521))(connect_data=(sid=DVLPBIS)))" but I'm not able to use tnsnames. I've cre... 11 Jul 2006 19:25
ORA 1801 - Dateformat too long for internal buffer On one database table I got this strange error (Oracle 9.2.0.4 Linux) ORA-01801: Datumsformat zu lang f?r internen Puffer I found out that in a date column and in some rows the datevalue is "corrupted" If I make an update on this specific row and column everything works okay. But I am wondering how such inc... 31 Mar 2006 05:07
numeric check i just have a doubt. till date i was writing a pl sql function for checking whether the entered number is numeric or not. can anyone tell whether there is any built in function to check this? Earlier i was using isdigit() and isnumeric() in other languages. is this kind of functions available here? thanks in adva... 24 Apr 2006 16:34
Oracle 10g on Windows connection problem - ORA-12505 This is my problem: FAIL (Cannot create PoolableConnectionFactory (Listener refused the connection with the following error: ORA-12505, TNS:listener does not currently know of SID given in connect descriptor The Connection descriptor used by the client was: 192.168.1.7:1521:system A little googling describes... 20 Mar 2006 06:17
optimizer_secure_view_merging Hello, there is a new initialization parameter OPTIMIZER_SECURE_VIEW_MERGING in oracle 10gR2. The documentation says: OPTIMIZER_SECURE_VIEW_MERGING allows you to enable or disable view merging globally for the database. Can somebody give me a simple example (sqlplus) how the parameter works? Thank you! Regard... 13 Jan 2006 11:24
ORA-01779, update join view Hi there, I'm trying to solve an update, and simply can't find a way. It updates 1 table, that has a 3 column PK. See it here: update ( select t1.emp_cod t1emp, t1.cednte_cedn t1cedn, t1.titlo_noss_num t1noss, t1.titlo_num_versao, t2.emp_cod t2emp, t2.cednte_cedn t2cedn, t2.titlo_noss_num t2noss, t2.ren... 29 Dec 2005 08:00 |