subject_47904.htm

一些关于vc的问答

<p>
序号：47904 发表者：Diversity 发表日期：2003-07-25 11:05:18
<br>主题：如何在pl/sql里显示 out_number的值？
<br>内容：CREATE OR REPLACE PROCEDURE&nbsp;&nbsp;"OUT" <BR>(<BR>in_number&nbsp;&nbsp; in&nbsp;&nbsp;test.t1%type,<BR>out_number&nbsp;&nbsp;out test.t1%type<BR><BR>)<BR>AS<BR><BR><BR>BEGIN<BR><BR>out_number:=in_number+3;<BR> <BR>END;<BR><BR><BR>如何在pl/sql里显示 out_number的值？
<br><a href="javascript:history.go(-1)">返回上页</a><br><a href=http://www.copathway.com/cndevforum/>访问论坛</a></p>
<hr size=1>
<blockquote><p>
<font color=red>答案被接受</font><br>回复者：投河自尽的鱼 回复日期：2003-08-03 20:25:45
<br>内容：set serverout on<BR>DBMS_OUTPUT.PUT_LINE(out_number);
<br>
<a href="javascript:history.go(-1)">返回上页</a><br><a href=http://www.copathway.com/cndevforum/>访问论坛</a></p></blockquote>
<hr size=1>
<blockquote><p>
回复者：Diversity 回复日期：2003-08-03 22:21:41
<br>内容：<BR><BR>set serverout on<BR><BR>这个在哪设？ 过程里吗？<BR><BR>
<br>
<a href="javascript:history.go(-1)">返回上页</a><br><a href=http://www.copathway.com/cndevforum/>访问论坛</a></p></blockquote>
<hr size=1>
<blockquote><p>
回复者：投河自尽的鱼 回复日期：2003-08-04 09:18:25
<br>内容：serverout 只是一个运行环境变量而已<BR>当然在外部设定，或者将serverout on<BR>改成默认方式（在init文件里）<BR>
<br>
<a href="javascript:history.go(-1)">返回上页</a><br><a href=http://www.copathway.com/cndevforum/>访问论坛</a></p></blockquote>
<hr size=1>
<blockquote><p>
回复者：兔子你往哪里跑 回复日期：2003-08-11 14:50:08
<br>内容：SQL&gt; set serverout on<BR>SQL&gt; CREATE OR REPLACE PROCEDURE&nbsp;&nbsp;"OUT"<BR>&nbsp;&nbsp;2&nbsp;&nbsp;(<BR>&nbsp;&nbsp;3&nbsp;&nbsp;&nbsp;&nbsp;in_number&nbsp;&nbsp; in&nbsp;&nbsp;test.t1%type,<BR>&nbsp;&nbsp;4&nbsp;&nbsp;&nbsp;&nbsp;out_number&nbsp;&nbsp;out test.t1%type<BR>&nbsp;&nbsp;5&nbsp;&nbsp;)<BR>&nbsp;&nbsp;6&nbsp;&nbsp;AS<BR>&nbsp;&nbsp;7&nbsp;&nbsp;<BR>&nbsp;&nbsp;8&nbsp;&nbsp;BEGIN<BR>&nbsp;&nbsp;9&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; out_number:=in_number+3;<BR> 10&nbsp;&nbsp;END;<BR> 11&nbsp;&nbsp;/<BR><BR>Procedure created<BR><BR>SQL&gt; DECLARE<BR>&nbsp;&nbsp;2&nbsp;&nbsp;&nbsp;&nbsp;IN_NUMBER NUMBER;<BR>&nbsp;&nbsp;3&nbsp;&nbsp;&nbsp;&nbsp;OUT_NUMBER NUMBER;<BR>&nbsp;&nbsp;4&nbsp;&nbsp;<BR>&nbsp;&nbsp;5&nbsp;&nbsp;BEGIN<BR>&nbsp;&nbsp;6&nbsp;&nbsp;&nbsp;&nbsp;IN_NUMBER := 1;<BR>&nbsp;&nbsp;7&nbsp;&nbsp;&nbsp;&nbsp;OUT_NUMBER := NULL;<BR>&nbsp;&nbsp;8&nbsp;&nbsp;<BR>&nbsp;&nbsp;9&nbsp;&nbsp;&nbsp;&nbsp;OUT ( IN_NUMBER, OUT_NUMBER );<BR> 10&nbsp;&nbsp;<BR> 11&nbsp;&nbsp;&nbsp;&nbsp;DBMS_OUTPUT.PUT_LINE(OUT_NUMBER);<BR> 12&nbsp;&nbsp;END;<BR> 13&nbsp;&nbsp;/<BR>4<BR><BR>PL/SQL procedure successfully completed
<br>
<a href="javascript:history.go(-1)">返回上页</a><br><a href=http://www.copathway.com/cndevforum/>访问论坛</a></p></blockquote>