Naval

hi,
I am trying to pass date to an oracle function but i am getting an error

PLS-00306:wrong number or types of arguments in call to LOAD.

// Nmis_Extract is an oracle stored procedure which has a function name load.
Load has four parameters.
(Startdate,enddate,file,folder)
end date need to be passed to this function.

Code used

SQL
BEGIN

:#RESULT := Nmis_Extract.load(NULL,:#END_DATE,:$$TRIG_FILE ,:$$TARGET_DIR);

END ;

Please help me on this.

Regards,
Naval

I am unable to pass the parameter to Task below is the code i am using. Could anyone please tell what is wrong with the code. I am using Concerto.

<script runat="server">
TaskB = new Task(request.xmlTaskName, request.exampleHostName, request.exampleCoDiv, request.exampleOpr, request.exampleProivPassword, request.exampleId, request.exampleSysPassword, request.exampleEnvironment, request.examplePort);

//-- PASSING PARAMETERS TO TASK------------------//
TaskB.parameters.NoticeType = request.NoticeType;
TaskB.parameters.Number = request.NoticeNumber;
//-----------------------------------------------------------//

TaskB.disableOutput = true; // Don't display the raw, unformatted report output.
TaskB.collectReports = true; // Collect the report output.
if(TaskB.execute()) { // Execute the task.
// Iterate through the reports in the task (one in this case).
while(TaskB.nextReport()) {
// if the report is valid XML then an XML string will be returned to the script developer
// but it is always wise to check that you've got what you expected
// check to see if the report output is an array, if it isn't then we've got xml
if(TaskB.reportOutput.isArray){
writeln("Returned report is not valid XML");
}
else
forward("Noticexml.xsp?xml="+escape(TaskB.reportOutput));
}
}
else {
writeln("Task execution error - " + TaskB.error);
}


regards,
Naval

hi,
I am getting an error while trying to access database through proiv function.
System Error : E373
SystemErr Desc : c:\SUPPORT\55\OVN01\proora815.DLL.

I have mentioned
ORACLE_DLLNAME=c:\SUPPORT\55\OVN01\proora815.DLL in proiv.ini file.

Does anybody have this DLL.

regards,
Naval