...
For the connection to the Oracle™ RDBMSDB we use the pl/sql script plsql_script.txt which is executed by the JAVA-AdapterClass [
{*}sos.scheduler.db.JobSchedulerPLSQLJobJSAdapterClass{*}.
The pl/sql The http://www.oracle.com/technetwork/database/features/plsql/index.html?ssSourceSiteIh1. ocomtr pl/sql.] script is defined as
| Code Block |
|---|
declare
status varchar2(64);
sourcefilepath varchar2(2048);
sourcefilename varchar2(2048);
targetfilepath varchar2(2048);
targetfilename varchar2(2048);
encryptedyn varchar2(16);
begin
select STATUS, SOURCEFILEPATH, SOURCEFILENAME, TARGETFILEPATH, TARGETFILENAME, ENCRYPTEDYN
into status, sourcefilepath, sourcefilename, targetfilepath, targetfilename, encryptedyn
from scenario1;
dbms_output.put_line('status=' || status);
dbms_output.put_line('sourcefilepath=' || sourcefilepath);
dbms_output.put_line('sourcefilename=' || sourcefilename);
dbms_output.put_line('targetfilepath=' || targetfilepath);
dbms_output.put_line('targetfilename=' || targetfilename);
dbms_output.put_line('encryptedyn=' || encryptedyn);
end;
|
...