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
merawalaid
Messages: 2
Registered: May 2007
Junior Member
Hi,
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:
CREATE OR REPLACE PROCEDURE "TEST"."MYPROCNAME"
(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);

SQLExecute(handelToSTMT);


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
rfriedl
Messages: 1
Registered: April 2008
Junior Member
Hello,

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 ??

Regards
Robert
Previous Topic: ┬┐┬┐LAST_DML_TIME??
Next Topic: Commit after DDL
Goto Forum:
  


Current Time: Sat Dec 03 13:43:33 CST 2016

Total time taken to generate the page: 0.09462 seconds