Listener problem in Oracle 8.1.5 for RH 6.2
Hi All I have problem related to listener. On my machine I have Oracle 8.1.5 on RH 6.2. When I issued the command $ lsnrctl I got the following error message lsnrctl: error in loading shared libraries: libskgxp8.so: cannot open shared object file: No such file or directory I have downloaded the library from rpmfind.net and installed it from root user on my machine. My file libskgxp8.so is located in $ORACLE_HOME/lib. However still when I say $ lsnrctl then I get the above error. Is that file is not used or what? I have also restarted my machine but it is still not working. I already have these settings in my .bash_profile. But it is not working. Does anyone has the solution for this problem? LD_LIBRARY_PATH=/u01/app/oracle/product/8.1.5/lib; export LD_LIBRARY_PATH Amol _ Click below to visit monsterindia.com and review jobs in India or Abroad http://monsterindia.rediff.com/jobs -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Nandu Garg INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line 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).
Re: RE: Move index to another tablespace
ya it is even possible in 8.1.5 NG On Tue, 02 Apr 2002 CHAN Chor Ling Catherine (CSC) wrote : Hi Ayyappan, Correct me if I am wrong. I think in 8.1.6, you can use the alter index command to move an index to a different tablespace eg. ALTER INDEX summit.orders_idx REBUILD TABLESPACE new_tablespace_name; Regds, New Bee -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Tuesday, April 02, 2002 12:03 PM To: Multiple recipients of list ORACLE-L Subject:RE: Move index to another tablespace Hi U have to rebuild the index only. u can't able to move from one tablespace to another like move table. Regards Ayyappan.S This communication contains information, which is confidential and may also be privileged. It is for the exclusive use of the intended recipient(s). If you are not the intended recipient(s), please note that any distribution, printing, copying or use of this communication or the information in it is strictly prohibited. If you have received this communication in error, please notify the sender immediately and then destroy any copies of it. Visit us @ www.ssiworldwide.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line 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: CHAN Chor Ling Catherine (CSC) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line 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: Nandu Garg INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line 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).
Re: RE: CASE under Oracle8i
Hi I was not knowin about CASE functionality so was just trying curiously following thing. Results are also below. SQL select case when mgr is null then ename end from emp; CASEWHENMG -- KING CASEWHENMG -- 14 rows selected. This gives me all 14 rows. Can I get outout as just 'KING' here using CASE? Also what are the other usage of CASE functionality? NG -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Nandu Garg INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line 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).
Calling a Stored procedure from Java which returns cursor value
Hi all I was running following code in from this list only and I want to call it from java code. Code is CREATE OR REPLACE PACKAGE Apack AS TYPE RefCurTyp IS REF CURSOR; END APACK; / CREATE OR REPLACE PROCEDURE demo_ref ( refcurvar IN OUT Apack.RefCurTyp, choice NUMBER) IS BEGIN IF choice = 1 THEN OPEN refcurvar FOR SELECT * FROM emp; ELSIF choice = 2 THEN OPEN refcurvar FOR SELECT * FROM dept; ELSIF choice = 3 THEN OPEN refcurvar FOR SELECT * FROM salgrade; END IF; END demo_ref; / The procedure above works very fine if I just execute it on SQL after declaring a refcursor variable x SQL exec demo_ref(:x,2). BUT How to run this procedure from Java Code. I can use 'Call' statement in Java and ? ? as variables , however what will replace :x on Oracle in Java file. I am still having problems in calling it from java. (I can convert it to function and then call it successfully from java , but I think there must be some way out in Java for calling SP) NG P.S. I can call SP from java which is accepting parameter but not returnin value. Amol -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Nandu Garg INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line 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).
Re: RE: what pl/sql construct can return multiple rows?
Hi Bill I have written your procedure as below. How to execute it from SQL prompt. I am geting problem when I say SQL exec demo_ref(2). ERROR at line 1: ORA-06550: line 1, column 13: PLS-00306: wrong number or types of arguments in call to 'DEMO_REF' ORA-06550: line 1, column 7: PL/SQL: Statement ignored What should I pass as the first parameter. Amol -Original Message- Sent: Tue, March 19, 2002 12:19 PM To: Multiple recipients of list ORACLE-L Lots of examples avlbl from Concepts manual; also pl check asktom.com Step 1) Declare a ref cursor inside a package CREATE PACKAGE APACK AS TYPE RefCurTyp IS REF CURSOR; END APACK; Step 2) Employ the ref curosr IN OUT variable inside the procedure..note that the cursor is opened but not fetched.. PROCEDURE demo_ref ( refcurvar IN OUT RefCurTyp, choice NUMBER) IS BEGIN IF choice = 1 THEN OPEN refcurvar FOR SELECT * FROM emp; ELSIF choice = 2 THEN OPEN refcurvar FOR SELECT * FROM dept; ELSIF choice = 3 THEN OPEN refcurvar FOR SELECT * FROM sal; END IF; END demo_ref; -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Magaliff, Bill INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line 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: Nandu Garg INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line 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).
Is Couchman book good for OCP SQL PLSQL
Hi I am using Oracle 8i SQL and PLSQL exam guide by Jason Couchman for my preparation of OCP. Is it good or do I need any other Book (for e.g. Advance PLSQL by Oracle Press OR Exam Cram) Amol -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Nandu Garg INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line 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).
Handling Exception in query outputting refcursor block
Hi All I have following function returning refcursor: create or replace function Lemp(eno in number) return cowave_pack1.cursortype is l_cursor cowave_pack1.cursorType; begin open l_cursor for select ename, empno, job from emp where empno = eno; return l_cursor; exception when no_data_found then dbms_output.put_line('t1'); end; / This function on execution returns data correctly if I pass correct empno but does not go to the exception block if I enter th wrong value. What is required to be done if I want to catch this exception. Amol -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Nandu Garg INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line 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).
which query is ok in different environment
Hi All I have a 2 tables which related to each other Nemaster(primary key is Oid) and Elements (Neid reference Oid) Now I have to run following query A) SELECT IPADDRESS FROM ELEMENTS WHERE NEID = (SELECT OID FROM NEMASTER WHERE EID = ID); I can run the above query as below B) SELECT IPADDRESS FROM NEMASTER A, ELEMENTS B WHERE A.OID = B.NEID AND A.EID = @ID; If my Nemaster table is going to be bulkier and if I am using above queries in FUNCTIONS then how I should call the query. By method A or B. Amol -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Nandu Garg INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line 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).
Any Oracle Tool
Hi All I am facing a lot of problems in testing Stored Procedures and Functions. I have many functions which requires a lot of parameters to be passed. Even a small mistake make me lot of retype. Again testing everything against requires a lot of testing data. If any good UI is available it makes easier even to taste functions and Enter Data. I ll be very much glad if any information is passed . Thanks in Advance -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Nandu Garg INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line 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).
Which Book should I use for SQL/PLSQL OCP
Hi All Can anyone recommend me the book for SQL/PLSQL OCP exam paper. I would like to know the book which will be guiding me thoroughly Amol -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Nandu Garg INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line 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).