tenaka
asked on
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
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
ASKER
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
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
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
You're a life saver. Exactly what I was after.
t
t
Thaks for your comments.
Select myProc form User_objects
Regards,
Coggie