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';
entry that i have
done on the Win NT server, there by connecting to the Non Oracle database.
SqlServer ---odbc setup on NT Win NT ( LIstener Entry: pubs)
Unix (Tnsnames entry : pubs.world)
can this be done ??
Regards,
Sunil Gompa
--
Please see the official ORACLE-L FAQ
machine to this Listener on
NT.
Regards,
Sunil Gompa
-Original Message-
Sent: Wednesday, February 05, 2003 3:05 PM
To: [EMAIL PROTECTED]; Multiple recipients of list ORACLE-L
NO, you have to do it the otherway around with Heterogenous services. Namely
ODBC on the Unix platform.
Dick
Hi
Anyone has used Oracle under Solaris/Sun C++ compiler . If yes please mail me how and on whichversion.
Sunil AroraSunil AroraVichara TechnologiesDo you Yahoo!?
Yahoo! Mail Plus - Powerful. Affordable. Sign up now
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
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
containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: sunil
INET: [EMAIL PROTECTED]
Fat City Network Services
hi,
Anybodygot some oracle
question dumps or resources for
oracle certified
internet database administrator exam ?? (exam #1Z0
-411).
Thanks in advance
:)
rgds
sunil