| View previous topic :: View next topic |
| Author |
Message |
Bert Prins
Guest
|
 Posted: Wed Sep 24, 2003 6:33 am Post subject: Retrieve Stored Procedures text |
 |
|
Hallo!
In a Delphi-application I need to show the text of a stored procedure,
stored in an Interbase or Informix database. Can someone tell me how to do
that?
Bert Prins
Netherlands
|
|
| Back to top |
|
 |
heiko Luettge
Guest
|
| Posted: Wed Sep 24, 2003 11:24 am Post subject: Re: Retrieve Stored Procedures text |
|
|
For Interbase
system table: rdb$procedures
field names:
rdb$procedure_name - name of the stored procedure
rdb$procedure_source -source od the stored procedure
rdb$procedure_blr - compiled source of the sp
Interbase do not use the rdb$procedure_source, so this field can be empty,
if the database developer wanted to hide the details of the sp.
Heiko
|
|
| Back to top |
|
|
Bert Prins
Guest
|
| Posted: Wed Sep 24, 2003 3:19 pm Post subject: Re: Retrieve Stored Procedures text |
|
|
Thanks!
"heiko Luettge" <luettge (AT) boerde (DOT) de> schreef in bericht
news:bkrv1m$eep$1 (AT) news (DOT) boerde.de...
| Quote: |
For Interbase
system table: rdb$procedures
field names:
rdb$procedure_name - name of the stored procedure
rdb$procedure_source -source od the stored procedure
rdb$procedure_blr - compiled source of the sp
Interbase do not use the rdb$procedure_source, so this field can be empty,
if the database developer wanted to hide the details of the sp.
Heiko
|
|
|
| Back to top |
|
|
|
FAQ
Search
Memberlist
Usergroups
Register
Profile
Log in to check your private messages
Log in
