Home » SQL & PL/SQL » SQL & PL/SQL » oracle 10g procedure ORA-06550 + PLS-00103
icon4.gif  oracle 10g procedure ORA-06550 + PLS-00103 [message #238332] Thu, 17 May 2007 07:35 Go to next message
Messages: 2
Registered: May 2007
Karma: 0
Junior Member
i have a old vc++ application which calls a stored procedure. This application has been in use for a long time. Earlier the Database server and client were both oracle 9i. Now we moved the server and some of the clients to 10g.
The application still works from machine with 9i clients (with older odbc drivers) but from machines with 10g client (with newer odbc drivers) i get the following error:

PLS-00103: Encountered the symbol "end-of-file" when expecting one of the following:
( ) - + case mod new not null others <an identifier> table avg count current exists max min prior sql stddev sum .........

Finally i also get:
[Oracle][ODBC][Ora]ORA-06550: line 1, column 16

The procedure has three parameters which it recieves as type NUMBER. The procedure is defined as:
(prm1 NUMBER, prm2 NUMBER, prm3 NUMBER) AS
/*...body of the procedure...*/

The process flow in application code (vc++) goes something like this:
SQLBindParameter(handelToSTMT,1, SQL_PARAM_INPUT, SQL_C_SSHORT, SQL_INTEGER, sizeof(parm1), 0, &parm1, 0, NULL);

SQLBindParameter(handelToSTMT,2, SQL_PARAM_INPUT, SQL_C_SSHORT, SQL_INTEGER, sizeof(parm1), 0, &parm2, 0, NULL);

SQLBindParameter(handelToSTMT,3, SQL_PARAM_INPUT, SQL_C_SSHORT, SQL_INTEGER, sizeof(parm1), 0, &parm3, 0, NULL);

SQLPrepare(handelToSTMT,"{call myProcName(?, ?, ?)}",SQL_NTS);


Is there some change in how 10g odbc parameter bindings work? Can it be possible to change the procedure to compensate for that?
Re: oracle 10g procedure ORA-06550 + PLS-00103 [message #352895 is a reply to message #238332] Fri, 10 October 2008 02:11 Go to previous message
Messages: 1
Registered: April 2008
Karma: 0
Junior Member

did you solve the problem ? How did you get it work with 10g clients ??
I'm just dealing with the same problem. Can you help me ??

Previous Topic: functions
Next Topic: how to use an cursor for loop
Goto Forum:

Current Time: Tue Aug 22 10:03:20 CDT 2017

Total time taken to generate the page: 0.01957 seconds