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

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

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> v

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 PROT

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-5

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

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:

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 -

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 / Mailin

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-

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

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: ht

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,

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-- Pu

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

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] F

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