如何打开存储过程并在SQL * Plus中对其进行编辑 [英] How do I Open a Stored Procedure and Edit it in SQL*Plus

问题描述

我需要在一个过时的盒子上对旧的Oracle存储过程进行一些更改，该盒子可以保留以运行旧的旧式进程.我可以使用的唯一连接到数据库的工具是SQL Plus.如何将存储的proc加载到内存中以在SQL Plus中进行编辑?

I need to make some changes to an old Oracle stored procedure on an obsolete box that is being kept around to run an old legacy process. The only tool I can connect to the db with is SQLPlus. How do I load a stored proc into memory for editing in SQLPlus?

我在网上找到的教程并没有解释这是怎么做的. :-(

The tutorials I've found on-line don't exlain how that's done. :-(

推荐答案

此框是没有运行TNS侦听器的HPUX，这几乎消灭了整个开发工具.但是，DBA能够使用称为OEM的管理工具进行连接并进行必要的更改.谢谢大家的建议.

The box is HPUX with no TNS listener running which pretty much wipes out the entire fleet of dev tools. However, the DBA was able to connect using an admin tool called OEM and make the necissary changes. Thanks all for your suggestions.

这篇关于如何打开存储过程并在SQL * Plus中对其进行编辑的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！