This thread looks to be a little on the old side and therefore may no longer be relevant. Please see if there is a newer thread on the subject and ensure you're using the most recent build of any software if your question regards a particular product.
This thread has been locked and is no longer accepting new posts, if you have a question regarding this topic please email us at support@mindscape.co.nz
|
When we are passing a null value to a stored procedure (Oracle DB, parameter type varchar2) we get an error ORA-06550: line 1, column 7:\nPLS-00306: wrong number or types of arguments in call to ...
If we set the value to "" or a value, everything works fine. Is this a known issue?
|
|
|
This might be a parameter type inference issue at our end, or it might be something to do with the way Oracle handles strings. Could you provide us with the Oracle stored procedure declaration (don't need the body) and the application code that calls the sproc? (If you are using a designer generated wrapper, please also provide the wrapper method definition from the generated .lsmodel.cs file.) Thanks! |
|
|
Here it goes: public System.Collections.Generic.IList Izvodiknparam(string psifrapartije, string psifravalute, int pgodinaizv, int pbrojizvodaod, int pbrojizvodado, System.DateTime ppocetnidatum, System.DateTime pzavrsnidatum, int psortiranje, string pposjed) { ProcedureParameter psifrapartijeParameter = new ProcedureParameter("psifrapartije", psifrapartije); ProcedureParameter psifravaluteParameter = new ProcedureParameter("psifravalute", psifravalute); ProcedureParameter pgodinaizvParameter = new ProcedureParameter("pgodinaizv", pgodinaizv); ProcedureParameter pbrojizvodaodParameter = new ProcedureParameter("pbrojizvodaod", pbrojizvodaod); ProcedureParameter pbrojizvodadoParameter = new ProcedureParameter("pbrojizvodado", pbrojizvodado); ProcedureParameter ppocetnidatumParameter = new ProcedureParameter("ppocetnidatum", ppocetnidatum); ProcedureParameter pzavrsnidatumParameter = new ProcedureParameter("pzavrsnidatum", pzavrsnidatum); ProcedureParameter psortiranjeParameter = new ProcedureParameter("psortiranje", psortiranje); ProcedureParameter pposjedParameter = new ProcedureParameter("pposjed", pposjed); ProcedureQuery procedureQuery = new ProcedureQuery("IZVODIKNPARAM", psifrapartijeParameter, psifravaluteParameter, pgodinaizvParameter, pbrojizvodaodParameter, pbrojizvodadoParameter, ppocetnidatumParameter, pzavrsnidatumParameter, psortiranjeParameter, pposjedParameter); System.Collections.Generic.IList valueToReturn = Find(procedureQuery); return valueToReturn;
CREATE OR REPLACE PROCEDURE izvodi.izvodiknparam (
CoreLibraryModelUnitOfWork iow = Repository.Context.CreateUnitOfWork(); |
|
|
Sorry about the first part...
public System.Collections.Generic.IList<IzvodiknparamAnjaResult> IzvodiknparamAnja(string psifrapartije, string psifravalute, int pgodinaizv, int pbrojizvodaod, int pbrojizvodado, System.DateTime ppocetnidatum, System.DateTime pzavrsnidatum, int psortiranje, string pposjed) |
|
|
Thanks Delfino. We have reproduced the problem and implemented a candidate fix, which will be included in nightly builds dated 30 Apr 2009 and above, available from about 1430 GMT. Please let us know if you see any problems. |
|
|
Perfect! Thank you. |
|