Calling oracle stored proc from .net and getting PLS-00201: -

Calling oracle stored proc from .net and getting PLS-00201: -

i not sure going on here. of sudden having hard time calling stored procs used called pretty easily. above exception.

when phone call them in sql developer work fine. need update connection string or dll or something?

update: code added

if (implemtation == 1) sproc = "xxx.xxxxx"; else if (implemtation == 2) sproc = "xxx.xxxxx"; else throw new exception(string.format("error determening stored proc... stored proc: {0}",(sproc == "" ? "empty" : sproc))); seek { using (oracleconnection conn = new oracleconnection(configurationmanager.connectionstrings["acodbconnectionstring2"].connectionstring)) { ///not simple getting oracle info .net... however, these code sections it... ///consider placing section own method more object oriented application... little time consider using (oraclecommand cmd = new oraclecommand(sproc, conn)) { conn.open(); cmd.commandtype = commandtype.storedprocedure; oracleparameter inputparm = new oracleparameter("xxxxin", oracledbtype.decimal); oracleparameter inputparm2 = new oracleparameter("xxxxin", oracledbtype.decimal); oracleparameter inputparm3 = new oracleparameter("xxxxin", oracledbtype.decimal); inputparm.value = double.parse(popid); inputparm2.value = double.parse(history); inputparm3.value = double.parse(isactive); oracleparameter outrefparam = new oracleparameter("cur_out", oracledbtype.refcursor, dbnull.value, parameterdirection.output); cmd.parameters.add(inputparm); cmd.parameters.add(inputparm2); cmd.parameters.add(inputparm3); cmd.parameters.add(outrefparam); adapter = new oracledataadapter(cmd); adapter.fill(ds); //cmd.executenonquery(); acodata = serializeoracledata(ds); } } }

this same code working few days ago.

.net oracle stored-procedures