[no subject]

hi, can i use a database link inside a procedure to refresh data from a AS/400 system into oracle ?? this is the sample of the code that i am using ... and it hangs endlesly... CREATE OR REPLACE PROCEDURE PRC_TABLE_REFRESH AS BEGIN execute immediate 'alter session set global_names=false';

Connecting to Non Oracle databases from Oracle

Hi, I am trying to connect to a Non Oracle database from the Oracle database ( Version 8.1.7.4). i want to do some thing like this : i have my ODBC set up on an Win NT machine. I have created a heterogeneous connection set up on Win NT. Now i want to connect from a Unix machine to the Listener

RE: Connecting to Non Oracle databases from Oracle

i was successfull in connecting to a Non oracle database from Oracle on unix through the Listener on Win NT. this situation arose b'cos we did not have a ODBC setup on Unix. So we had to do the ODBC as well as the Heterogeneous services setup on Win NT. and then try to connect from databse on Unix

RE: how to change nls date format.

NLS_LANGUAGE - AMERICAN Charset WE8ISO8851 Thanks in advance Sunil Gompa -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sunil Kumar INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California

how to change nls date format.

Oracle 8.1.6 OS - Windows NT NLS_TERRITORY - AMERICA NLS_LANGUAGE - AMERICAN Charset WE8ISO8851 Thanks in advance Sunil Gompa -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sunil Kumar INET: [EMAIL PROTECTED] Fat City