How to View Oracle Stored Procedure using SQLPlus?

oracle stored-procedures oracle10g sqlplus
Madam Zu Zu picture Madam Zu Zu · Aug 9, 2011 · Viewed 131.7k times · Source

How can I view the code of a stored procedure using sqlplus for Oracle 10g?

When I type in:

desc daily_update;

it shows me the parameter, but when I try to do the following:

select * from all_source where name = 'daily_update';

I get

no rows selected

What am I doing wrong?

Answer

Harrison picture Harrison · Aug 9, 2011

check your casing, the name is typically stored in upper case

SELECT * FROM all_source WHERE name = 'DAILY_UPDATE' ORDER BY TYPE, LINE;

Related questions

How do I find out when a stored procedure was last modified or compiled in Oracle?

I'm preferably looking for a SQL query to accomplish this, but other options might be useful too.

Read More
When should I use 'for update nowait' in cursors?

In which case do we need to use for update nowait in cursors.

Read More
Cannot call oracle stored procedure and function

Might be too simple question to ask, but I do need help. I am creating a stored procedure in Oracle 10g, but I cannot call it. I am using SQL Developer to manage the database. CREATE OR REPLACE FUNCTION check_…

Read More