Re: DBMS_PIPEs problem

From: Dmitry L. Zhuk <dmitry_at_leaves.spb.su>
Date: 1997/03/21
Message-ID: <333278BA.885@leaves.spb.su>#1/1

For escape this problem I create package.

select sys.jobseq.nextval into package_variable from dual;
create pipes with name name_pipes||package_variable;
dbms_job.isubmit(package_variable,'package_procedure_correct('|| package_variable||'); '||calling_programm||';',sysdate);commit; 4.package_procedure_correct(package_variable) - this procedure corect package_variable in calling_programm session.
And no problem.

I hope this algorithm help you.

The best regards.

Dmitry L. Zhuk
Leaves Inc. Russia. Received on Fri Mar 21 1997 - 00:00:00 CST