ORA-06550

[Swosti Dipan Pal]

Hi,

I am getting the following error while executing a Oracle procedure in Java. Can anyone is aware of such issue ?

ORA-06550: line 1, column 60:
PLS-00103: Encountered the symbol ";" when expecting one of the following:

) , * & | = - + < / > at in is mod not rem => ..
<an exponent (**)> <> or != or ~= >= <= <> and or like as
between from overlaps using || year DAY_
The symbol ")" was substituted for ";" to continue.

Cheers,
-Biswa

[Masoud Kalali]

can you post your code portion that cause this error ?
it will help to understand what cause that error.

[Swosti Dipan Pal]

 
try
{
// XMLGenerator Object Creation
 
PEParameter wiParameters  = new PEParameter();
EDSRDAO objEDSRDAO = null;
HashMap hmAttributes = null;
String strTargetPage = null;
connList = new ConnectionList(); 
conn = (Connection) connList.getConnection("EDSR");
objEDSRDAO = new EDSRDAO(conn);
PEParameter userParam =(PEParameter) request.getAttribute("/projects/templates/CntryDebtMgmtDetails.jsp");
strXslSource =(String) userParam.getParameter("queryXSLSource");
strXML = "<?xml version=\"1.0\" encoding=\"UTF-8\"?>";
objEDSRDAO.setParams(wiParameters);
String countryCode =(String) userParam.getParameter("queryCountryCode");
String repDate = (String)request.getParameter("REPAYMENT_DT");
//String countryName = objEDSRDAO.getCtryName(countryCode);
String countryName = (String)request.getParameter("queryCountryName");
strUserPI = (String) userParam.getParameter("queryExcelURL");
strUserPageInstancePK = Integer.parseInt(strUserPI);
objectPI = null;
objectPI = SiteObjectsHelper.getPageInstance(strUserPageInstancePK);


out.println(" Object PI ------------------------------>" + objectPI);
System.out.println("REPAYMENT_DT " + repDate );
System.out.println("REPAYMENT_DT " + countryCode );

if (objectPI !=null) 
{
excelLink =objectPI.getBaseURL();
excelLink +="&CountryCode=" + countryCode + "&CountryName=" + countryName + "&RepaymentDt=" + repDate + "&Type=Details";
excelLink = CheckForSpecialCharacters(excelLink);
 }

strXML += objEDSRDAO.generateOpenTag("RECORDS");
strXML += "\n";

strXML += objEDSRDAO.generateOpenTag("pag");
strXML += "\n";
strXML += objEDSRDAO.generateTagWithData("ExcelURL",excelLink);
strXML += "\n";
strXML += objEDSRDAO.generateTagWithData("CountryCode", countryCode);
strXML += "\n";
strXML += objEDSRDAO.generateTagWithData("CountryName", ReplaceSpecialCharacters(countryName));
strXML += "\n";
strXML += objEDSRDAO.generateTagWithData("RepaymentDate", repDate);
strXML += "\n";
strXML += objEDSRDAO.generateTagWithData("PIDURL", "http://www4.worldbank.org/sprojects/Project.asp?");
strXML += "\n";
strXML += objEDSRDAO.generateCloseTag("pag");
strXML += "\n";
strXML += objEDSRDAO.generateOpenTag("COLUMNS");
strXML += "\n";
strXML += objEDSRDAO.generateOpenTag("COLUMN ID=\"1\"");
strXML += "Loan/<br/>Credit#";
strXML += objEDSRDAO.generateCloseTag("COLUMN");
strXML += "\n";
strXML += objEDSRDAO.generateOpenTag("COLUMN ID=\"2\"");
strXML += "Related<br/>Project ID";
strXML += objEDSRDAO.generateCloseTag("COLUMN");
strXML += "\n";
strXML += objEDSRDAO.generateOpenTag("COLUMN ID=\"3\"");
strXML += "Description";
strXML += objEDSRDAO.generateCloseTag("COLUMN");
strXML += "\n";
strXML += objEDSRDAO.generateOpenTag("COLUMN ID=\"4\"");
strXML += "Principal";
strXML += objEDSRDAO.generateCloseTag("COLUMN");
strXML += "\n";
strXML += objEDSRDAO.generateOpenTag("COLUMN ID=\"5\"");
strXML += "Charges";
strXML += objEDSRDAO.generateCloseTag("COLUMN");
strXML += "\n";
strXML += objEDSRDAO.generateOpenTag("COLUMN ID=\"6\"");
strXML += "Total";
strXML += objEDSRDAO.generateCloseTag("COLUMN");
strXML += "\n";
strXML += objEDSRDAO.generateCloseTag("COLUMNS");
strXML += "\n";

String strReportHeader = objEDSRDAO.getReportHeader();

out.println("strReportHeader successful---->" + strReportHeader);

String strNotes = objEDSRDAO.getNotes();

out.println("strNotes successful---->" + strNotes);
String strDetailReport = objEDSRDAO.getDetailReportCAR(countryCode, repDate);

out.println("strDetailReport successful---->" + strDetailReport);

if(strNotes.equals("Error") ||strReportHeader.equals("Error") || strDetailReport.equals("Error"))
{
boolResult = false;
}
else
{
boolResult = true;
}
 
if(boolResult)
{
strXML += strReportHeader.substring(22);
strXML += strNotes.substring(22);
strXML += strDetailReport.substring(22);
}

strXML += objEDSRDAO.generateCloseTag("RECORDS");
//close connection
objEDSRDAO.releaseConnection();
}
catch(Exception ee)
{
   ee.printStackTrace();
 
     //logger.error("Projects:CAR :CountryDebtMgtDetails.jsp :Error Ahoy From Main."+ee.getMessage());

}
// added for the mode of connection.
finally 
{
// close connList 
if(connList != null)
{
connList.releaseConnections();
}
}
 

 

   

[George Stoianov]

Are you passing a static string of text in the proc or variable print that and you will have your answer if it is not obviuos run it in SQL*Plus and see if you get the same message.

Hope that helps.
George

[Swosti Dipan Pal]

String strDetailReport = objEDSRDAO.getDetailReportCAR(countryCode, repDate);

This is the line which is throwing the error. Because after this line the SOP is n't printed.

 
public String getDetailReportCAR(String countryCode, String repaymentDate) throws EDSRException, SQLException, IOException
{

String query = "{ ? = call EDSRPORTAL.GetDetailReport_inwbctryid((?, ?) }";
cstmt = conn.prepareCall(query);
 
cstmt.setString(2,countryCode);
cstmt.setString(3,repaymentDate);

System.out.println("countryCode ------------------>" + countryCode);
System.out.println("repaymentDate ------------------->" + repaymentDate);

 
String result = execute();

System.out.println("result ------------------>" + result);
return result;
}
 

   

After getting the value in the log, we replace the value in the SQL. The results are coming up fine. I am unable to figure out what is causing the error.

Cheers,
-Biswa

[Swosti Dipan Pal]

I tried executing it in the Toad. It's coming up fine there.

Cheers,
-Biswa

[George Stoianov]

cstmt.setString(2,countryCode);
cstmt.setString(3,repaymentDate);

Do you have to set parameter 1???

If you have isolated the value and can run the procedure with these values, in something other than a tool that maybe escaping and formatting stuff, then look at the procedure call again try a different one in the same code with the same values. You have to poke around to find it.

Hope this helps.
George