• Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

ORA-06550

 
Swosti Dipan Pal
Ranch Hand
Posts: 70
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Author
Ranch Hand
Posts: 531
Java Mac OS X Netbeans IDE
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
can you post your code portion that cause this error ?
it will help to understand what cause that error.
 
Swosti Dipan Pal
Ranch Hand
Posts: 70
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
 
George Stoianov
Ranch Hand
Posts: 94
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Ranch Hand
Posts: 70
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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.



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
Ranch Hand
Posts: 70
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I tried executing it in the Toad. It's coming up fine there.

Cheers,
-Biswa
 
George Stoianov
Ranch Hand
Posts: 94
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator

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
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic