Novice: SQL syntax to get description of Stored procedure through ODBC ?

Hi,
 This is a fairly basic question. I'm using the ODBC API (through VB - though that's not relevant). My problem is I have a stored procedure on an oracle database that I want to  see. Through sqlplus all I have to do is DESCRIBE myProc.

How can I do something similar using the ODBC api (it doesn't like describe).

t
tenakaAsked:
Who is Participating?
 
sgantaConnect With a Mentor Commented:

Use this
SELECT TEXT FROM ALL_SOURCE
WHERE NAME = <proc name must be in UPPER>
ORDER BY LINE
/

GOOD LUCK!
0
 
coggieCommented:
Hi there try,

Select myProc form User_objects

Regards,

Coggie


0
 
tenakaAuthor Commented:
I've tried it already.
All I can get out of doing that is whether or not the procedure is valid. I want to see the actual text of the procedure. (On sybase sp_helptext does it).

Thanks anyway

t
0
 
tenakaAuthor Commented:
You're a life saver. Exactly what I was after.

t
0
 
sgantaCommented:
Thaks for your comments.

0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.