Solved

Conv72 to Convert Stored Procedures

Posted on 1999-01-04
4
361 Views
Last Modified: 2012-06-21
Has anyone use conv72.exe (as part of msspnt.exe) from Oracle to convert stored procedures.  When I run it from the command prompt on NT or Win95, it just stops waiting and I must abort to get back to the op.sys. prompt.  I'm certain that I have donwloaded the right versijon.
Any suggestion?
0
Comment
Question by:snydero
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
4 Comments
 
LVL 9

Expert Comment

by:konektor
ID: 1083535
I do not know what conv72.exe do but if you want to get procedure body you can do this via sql*plus :
set head off
spool c:\output.sql
select text from user_source where name='PROCEDURE_NAME' and type='PROCEDURE' order by line;
spool off;
0
 
LVL 1

Author Comment

by:snydero
ID: 1083536
I'm attempting to convert stored procedures to Oracle from Microsoft SQL 6.5.
0
 
LVL 3

Accepted Solution

by:
mordi earned 100 total points
ID: 1083537
I used it and it worked ok, converting a bunch of stp to Oracle.
I used the Cd version of Oracle companion v 3. I think you can get it free from Oracle.
Good luck.
0
 
LVL 1

Author Comment

by:snydero
ID: 1083538
Thanks mordi
I'm using a DOS window within Win95 and typing the followiing...
conv72 -P sp_xxx.sql  <enter>
and nothing happens.  I have also tried this in an NT server, and also with an outfile as
conv72 -P sp_xxx.sql sp_xyz.out
How did you use it?
0

Featured Post

On Demand Webinar: Networking for the Cloud Era

Did you know SD-WANs can improve network connectivity? Check out this webinar to learn how an SD-WAN simplified, one-click tool can help you migrate and manage data in the cloud.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Have you ever had to make fundamental changes to a table in Oracle, but haven't been able to get any downtime?  I'm talking things like: * Dropping columns * Shrinking allocated space * Removing chained blocks and restoring the PCTFREE * Re-or…
Shell script to create broker configuration file using current broker Configuration, solely for purpose of backup on Linux. Script may need to be modified depending on OS-installation. Please deploy and verify the script in a test environment.
This video shows, step by step, how to configure Oracle Heterogeneous Services via the Generic Gateway Agent in order to make a connection from an Oracle session and access a remote SQL Server database table.
This video shows how to configure and send email from and Oracle database using both UTL_SMTP and UTL_MAIL, as well as comparing UTL_SMTP to a manual SMTP conversation with a mail server.

707 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question