oracle-databasestored-proceduresoracle10gsqlplus

How to View Oracle Stored Procedure using SQLPlus?

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?

Solution

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

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