create or replace procedure PTest
(
TMPtable out VARCHAR2
)
IS
begin
TMPtable:='dddd';
end;
*************************************************在PL/sql中执行***********************************
declare
tempid varchar2(100);
begin
Ptest(tempid);
dbms_output.put_line(tempid);
end;