COBOL to Oracle
Hi List, Does anyone know of tools, or have had experience using tools, that will quickly convert COBOL code to Oracle. Any information you can provide would be greatly appreciated. Thanks in advance. Rick
Re: DBMS_JOB problem
Bill, Try putting a ';' after snap that may fix it. SQL> variable x number; SQL> begin 2 dbms_job.submit(:x,'statspack.snap;',sysdate,'sysdate + 1/24'); 3 end; 4 / I'm trying to use DBMS_JOB to schedule hourly statspack snaps. Per note on Metalink, I've try to run the following: SQL> variable x number; SQL> begin 2 dbms_job.submit(:x,'statspack.snap',sysdate,'sysdate + 1/24'); 3 end; 4 / begin * ERROR at line 1: ORA-06550: line 1, column 108: PLS-00103: Encountered the symbol "END" when expecting one of the following: := . ( @ % ; The symbol ";" was substituted for "END" to continue. ORA-06512: at "SYS.DBMS_JOB", line 79 ORA-06512: at "SYS.DBMS_JOB", line 131 ORA-06512: at line 2 Any ideas on this error? No helpful info on Metalink. Checked the status of the package, too: 1* select object_type, status from all_objects where object_name = 'DBMS_JOB' SQL> / OBJECT_TYPE STATUS -- --- PACKAGE VALID SYNONYM VALID Thanks bill -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Magaliff, Bill INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services - 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).
Initial User Login
Hello List, We are trying to force a user to change their password when they login to the system for the first time after the user has been created. Is there a view or another way to make that determination? Any help would be greatly appreciated. Thanks Rick -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: Installing Oracle 9i Developper suite
Stephane, This deals with Section 508 of the Rehabilitation Act. The following link gives additional info, should anyone have an interest http://www.access-board.gov/508.htm Hope this helps Rick -- 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).
Remote Links
Hi, I'm executing DML to three remote sites. The problem is that if there is a failure at a given site (i.e. the last site), the first two are commiting the transaction leavintg the third out of sync. We also noticed that the remote links stay connected. Shouldn't they disconnect after the transaction ends? Any ideas to solve this problem would be greatly appreciated. We are using version 8.0.5. Thanks for your help. Rick -- 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).
Re: Trigger exception problem
Kathy, I beleive the problem is in the exception handler: select process into v_process from v$session...This is returning multiple rows. Rick -- 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).
Re: OT: Order By Position and UNION
Larry, You can use column name if you only have two statements with your set operators. However, any more than that you must user positional. See below. 1 select empno, ename from emp 2 union 3 select deptno, dname from dept 4 union 5 select locid, room from location 6* order by empno SQL> / order by empno * ERROR at line 6: ORA-00904: invalid column name SQL> select empno, ename from emp 2 union 3 select deptno, dname from dept 4 union 5 select locid, room from location 6 order by 1 7 / EMPNO ENAME -- -- 10 ACCOUNTING 20 RESEARCH 30 SALES 40 OPERATIONS 45 101 46 202 47 103 48 105 49 105 50 404 51 421 52 211 53 424 54 402 55 433 56 217 57 222 7369 SMITH 7499 ALLEN 7521 WARD 7566 JONES 7654 MARTIN 7698 BLAKE 7782 CLARK 7788 SCOTT 7839 KING 7844 TURNER 7876 ADAMS 7900 JAMES 7902 FORD 7934 MILLER 31 rows selected. SQL>
SQL*Loader
Hi All, Does anyone have a good example of loading an image (i.e..jpg, .gif, etc) into a BLOB column using SQL*Loader. Looked through the docs and can't seem to find what I need. TIA Rick -- 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).
Re: Procedure Builder - Seeing variables
Eriovaldo, Check on the object navigator and expand the node with the 'Stack' and you should see your variables there. Also, from the menu you can select 'View'>>'Navigator Pane' and this will show the object navigator in the center of the PL/SQL Interpreter. Regards, Rick -- 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).
Re: [Q] does Personal ORACLE 8.1.7 support Win98?
Yes it is. I have it installed and it works fine. What problems are you havging Rick -- 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).
Re: [Q] does Personal ORACLE 8.1.7 support Win98?
Yes it is. I have it installed on my machine at home and it works fine. What problems are you havging Rick -- 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).
Re: [Q] does Personal ORACLE 8.1.7 support Win98?
Search your Personal Oracle CD and look for the readme file. Follow the instructions and it should work fine. The reason I say look at the readme is, I had problems initially and I was able to resolve them through the readme. Hope this helps. Rick -- 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).
Re: How to deal with special character like & in ' '
Helen, In SQL*Plus: set escape on insert into dept(dname) values ('A\&M'); That should work. Rick -- 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).
Re: Input truncated
Andrea, Make sure that at the end of your script you don't have additional returns and one hard return after the last command. (i.e. SET OFF SET OFF SELECT * FROM table / SET ON SET ON <>>> Hope this helps. Rick -- 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).
Re: formatting DBMS_OUTPUT
Try DBMS_OUTPUT.PUT_LINE(TO_CHAR(amount_x), '999,999')) Rick -- 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).
RE: formatting DBMS_OUTPUT
Thank you -- 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).
Re: PL/SQL Question after migrating from 7.3.4 to 8.1.7
Deen, If you want a table with the structure of a row in your uc9_correspondence, use THE '%ROWTYPE'as follows: TYPE tb_uc9_corres_type IS TABLE OF uc9_correspondence%ROWTYPE INDEX BY BINARY_INTEGER; Rick -- 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).