How to use SYS.DBMS_OUTPUT.PUT_LINE in ProC?

Hi, I have a problem with using oracle built in stored procedures in embadded C. It is impossible to compile my program by ProC. It says: sys.dbms_alert.remove( 'prolan_alert' ); ..1 PLS-S-00201, identifier 'SYS.DBMS_ALERT' must be declared sys.dbms_alert.remove( 'prolan_aler

RE: x server

There is a free downloadable package called Cygwin which gives you an X terminal.  I don't have the URL handy but you can google it.  Use the NASA download site, it is the fastest.  Download the default version.   HTH, Ruth -Original Message-From: [EMAIL PROTECTED] [mailto:[EMA

RE: oracle10g

What on earth does the g stand for?  RBG -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]On Behalf Of Adams, Matthew (GECP, MABG, 088130)Sent: Thursday, July 17, 2003 3:45 PMTo: Multiple recipients of list ORACLE-LSubject: oracle10g Gotta love oracle.

RE: DB shift

No, See the 8.1.7.4 patch set documentation and do it with a COLD database on the source side. Dick Goulet Senior Oracle DBA Oracle Certified 8i DBA -Original Message- Sent: Sunday, July 20, 2003 12:50 PM To: Multiple recipients of list ORACLE-L Hi All We are planning to Shift our D

RE: faq broke? -- Other options

Hey Bruce, Any possibility of making the bodies of the FatCity archived messages searchable, instead of just the subject? That's the only reason why I even bother with the orafaq search. Thanks, Rich Rich Jesse System/Database Administrator [EMAIL PROTECTED]

RE: Recent reports on outages caused by DB2 and 9iRAC issues

WOW! Those are some good stories to keep in mind... And some folks wonder why techies like working with computers more than working with people. ;-) Trying to be wise as a serpent and harmless as a dove... -Original Message- Sent: Friday, July 18, 2003 1:49 PM To: Multiple recipients o

RE: ORA-29540: class oracle/plsql/net/TCPConnection does not exist

Run initplsj.sql from $ORACLE_HOME/rdbms/admin. Dick Goulet Senior Oracle DBA Oracle Certified 8i DBA -Original Message- Sent: Sunday, July 20, 2003 12:49 PM To: Multiple recipients of list ORACLE-L Helo all, I have installed oracle JVM on oracle817, windows2000. Asper the doc from m

RE: Different Platform

NO, but don't transfer obj files from teh linus to sun boxex. Only move *.pc or *.c files & recompile. Dick Goulet Senior Oracle DBA Oracle Certified 8i DBA -Original Message- Sent: Sunday, July 20, 2003 12:50 PM To: Multiple recipients of list ORACLE-L Hi All Our production environ

Re: RAID select

Assuming that you have 3 physical devices (NON-RAID, RAID-1, and RAID-0+1) my quick-and-dirty take on this is: NON-RAID redo logs - mirrored by Oracle control logs - mirrored by Oracle ORACLE_HOME RBS01 RBS02 TEMP STAT(For PERFSTAT) RAID-1 SYSTEM

RE: Who Says Oracle does not listen

Title: RE: Who Says Oracle does not listen That’s not good enough. I don’t want to discard ANY exception. When dropping table, I don’t want to see error messages only if there is nothing to drop.  While if let’s say there is a problem with privileges, it will go unnoticed. Or, when addi

AW: Re: Object Types in PL/SQL

Hi Sorry for the late reply ... weekend ;). If I understand you correctly, you do the following: Use "normal" tables (a normalized data model ?), then create an additional Object Type for each table with methods to do DML on that table. From Java, only use stored procs/funcs to manipulate the

RE: ODBC Patch 8.1.5.7 where to download

Title: ODBC Patch 8.1.5.7 where to download technet.oracle.com.  Follow the download links.   Ciao Fuzzy :-) -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]On Behalf Of [EMAIL PROTECTED]Sent: Friday, July 18, 2003 15:49To: Multiple recipients of list ORACL

Re: ORA-29540: class oracle/plsql/net/TCPConnection does not exist

Hi Nirmal, I believe there is a bug in the installer and the following two steps are missing cd $ORACLE_HOME/plsql/jlib loadjava -user sys/ plsql.jar Do them yourself manually and you should be fine. Hope this helps Garry Gillies Database Administrator Business Systems Weir Pumps Lt

Re: ORA-29540: class oracle/plsql/net/TCPConnection does not exist

I have faced the same problem earlier. I had first deinsatalled the JVM and then tried to intalled. It had given succesfull installation status. But actully not installed. I have checked the metalink and finally come to conclusion that re-installation of JVM not work and only solution is rein

Re: RE: Different Platform

FORTE compiler On Mon, 21 Jul 2003 Richard Ji wrote : >So which compiler will you standarize on? GCC? >On Solaris I believe the Sun C Compiler is supported but not gcc, >though >you can make it work. > >-Original Message- >Sent: Sunday, July 20, 2003 12:50 PM >To:

Re: Re: DB shift

thanks a lot On Sun, 20 Jul 2003 Tanel Poder wrote : >Hi! > >When moving to binary compatible platform, you can directly copy >over the >files (and software). > >It's even possible with different versions of OS - like from >SunOS 2.6 to >Solaris 8. > >For upgrading to 8.1.7.

Re: Re: DB shift

Yes We will bedoing it thru exp/imp as downtime is there thanks On Mon, 21 Jul 2003 zhu chao wrote : >Hi, > I suggest you upgrade your old server from 8170 to 8174 and >then copy >the datafiles there. > Or if downtime is limited, you can use standby database to >switch

FW: Oracle Instances not starting up via services

Hi, I send this mail on friday, but it seems me not arrived to the list. Michal -Original Message- Sent: Friday, July 18, 2003 11:32 AM To: '[EMAIL PROTECTED]' Hi, my experience: 1. It is not possible to start instance through Terminal Services - svrmgrl produces ORA-12560 error. Ter

<    1   2