取存储过程的语句
16:24:54 SQL> SELECT TEXT FROM ALL_SOURCE WHERE OWNER='TEMP' AND NAME='RE' AND LINE= 1;TEXT
--------------------------------------------------------------------------------------------
function Re(s string) return varchar2 is实际:220
16:25:04 SQL> 然后对字符串进行处理
16:24:54 SQL> SELECT TEXT FROM ALL_SOURCE WHERE OWNER='TEMP' AND NAME='RE' AND LINE= 1;TEXT
--------------------------------------------------------------------------------------------
function Re(s string) return varchar2 is实际:220
16:25:04 SQL> 然后对字符串进行处理
我的存储过程都在包中,而且在包头中声明也不是一样,我的写法如下:select * from all_source where type='PACKAGE' and name=upper('package_name') and owner='owner_name'存储过程示例如下,取得的结果也是这样的
procedure spDocument_insert
(
P_DOCUID out documents.DOCUID%type,
P_STARTDEPTID in documents.STARTDEPTID%type,
P_WRITERID in documents.WRITERID%type,
P_WRITERNAME in documents.WRITERNAME%type,
P_WRITEDate in documents.WRITEDate%type,
P_DOCUTITLE in documents.DOCUTITLE%type,
P_DOCUCONTENT in documents.DOCUCONTENT%type
);
procedure spDocuments_Update
(
P_DOCUID in NUMBER,
P_STARTDEPTID in CHAR,
P_WRITERID in NUMBER,
P_WRITERNAME in CHAR,
P_WRITEDate in Date,
P_DOCUTITLE in VARCHAR2,
P_DOCUCONTENT in BLOB
);请问我该如何分析语法,有没有参考资料,请指点,谢谢