wood burning stoves*
The moose likes JDBC and the fly likes ORA-06550 Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of EJB 3 in Action this week in the EJB and other Java EE Technologies forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "ORA-06550" Watch "ORA-06550" New topic
Author

ORA-06550

Swosti Dipan Pal
Ranch Hand

Joined: Sep 23, 2005
Posts: 70
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


Thanks<br />-Swosti
Masoud Kalali
Author
Ranch Hand

Joined: Jul 08, 2004
Posts: 531

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


Masoud Kalali
Software Engineer - My Weblog - GlassFish Security
Swosti Dipan Pal
Ranch Hand

Joined: Sep 23, 2005
Posts: 70
George Stoianov
Ranch Hand

Joined: Jan 15, 2006
Posts: 94
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

Joined: Sep 23, 2005
Posts: 70
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

Joined: Sep 23, 2005
Posts: 70
I tried executing it in the Toad. It's coming up fine there.

Cheers,
-Biswa
George Stoianov
Ranch Hand

Joined: Jan 15, 2006
Posts: 94

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
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: ORA-06550
 
Similar Threads
Oracle Stored Procedure Problem
PL/SQL substitution variable
Problem in executing Oracle Function from JSP Page
ORA-06550: line 1, column 36: PLS-00103: Encountered the symbol ";"
Loadjava and user_objects table