下面是要建的存储过程,如果每行都加分号,恐怕无法正确执行吧。 CREATE OR REPLACE PACKAGE oracmd IS PROCEDURE exec(cmdstring IN CHAR); end oracmd; CREATE OR REPLACE PACKAGE BODY oracmd IS PROCEDURE exec(cmdstring IN CHAR) IS EXTERNAL NAME "system" LIBRARY exec_shell LANGUAGE C; end oracmd;
不是每行加分号,简单的说就是把换行都删掉 例如,把下面的语句create or replace procedure p as l_str varchar2(100); begin select sysdate into l_str from dual; dbms_output.put_line(l_str); end;删掉换行,换成 create or replace procedure p as l_str varchar2(100); begin select sysdate into l_str from dual; dbms_output.put_line(l_str); end;
用textarea?
如果是服务器控件的textbox就设置multiline属性就可以了
CREATE OR REPLACE PACKAGE oracmd IS PROCEDURE exec(cmdstring IN CHAR);
end oracmd;
CREATE OR REPLACE PACKAGE BODY oracmd IS
PROCEDURE exec(cmdstring IN CHAR)
IS EXTERNAL
NAME "system"
LIBRARY exec_shell
LANGUAGE C;
end oracmd;
不是每行加分号,简单的说就是把换行都删掉
例如,把下面的语句create or replace procedure p as
l_str varchar2(100);
begin
select sysdate into l_str from dual;
dbms_output.put_line(l_str);
end;删掉换行,换成
create or replace procedure p as l_str varchar2(100); begin select sysdate into l_str from dual; dbms_output.put_line(l_str); end;