[prev in list] [next in list] [prev in thread] [next in thread]
List: solid
Subject: retrieving stored procedure code
From: Arwin_Knöps <arwin () infopact ! nl>
Date: 1999-08-05 7:11:43
[Download RAW message or body]
How can I retrieve the code of a stored procedure from a solid database?
I've tried it with this:
select procedure_text from sys_procedures where
procedure_name='test_proc';
but this returns only the first piece off the code.
Does anybody know how to retrieve the whole procedure?
T.i.a.
Arwin Knöps
[Attachment #3 (text/html)]
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META content="text/html; charset=iso-8859-1" http-equiv=Content-Type>
<META content="MSHTML 5.00.2314.1000" name=GENERATOR></HEAD>
<BODY bgColor=#ffffff>
<DIV><FONT face=Arial size=2><SPAN class=390320307-05081999>How can I retrieve
the code of a stored procedure from a solid database?</SPAN></FONT></DIV>
<DIV><FONT face=Arial size=2><SPAN class=390320307-05081999>I've tried it
with this:</SPAN></FONT></DIV>
<DIV><FONT face=Arial size=2><SPAN class=390320307-05081999> select
procedure_text from sys_procedures where
procedure_name='test_proc';</SPAN></FONT></DIV>
<DIV><FONT face=Arial size=2><SPAN class=390320307-05081999>but this returns
only the first piece off the code.</SPAN></FONT></DIV>
<DIV><FONT face=Arial size=2><SPAN class=390320307-05081999>Does anybody know
how to retrieve the whole procedure?</SPAN></FONT></DIV>
<DIV><FONT face=Arial size=2><SPAN
class=390320307-05081999></SPAN></FONT> </DIV>
<DIV><FONT face=Arial size=2><SPAN
class=390320307-05081999>T.i.a.</SPAN></FONT></DIV>
<DIV><FONT face=Arial size=2><SPAN class=390320307-05081999>Arwin
Knöps</SPAN></FONT></DIV></BODY></HTML>
[prev in list] [next in list] [prev in thread] [next in thread]
Configure |
About |
News |
Add a list |
Sponsored by KoreLogic