c# - Oracle.ManagedDataAccess.Client.OracleException - ORA-01722: invalid number -

-

i working in .net 4.5 c#, oracle 11g environment.

i experiencing peculiar behaviour, when call following sql statement code using datacontext

i ora-01722: invalid number

enter image description here

stacktrace:

   @ corp.dataservices.executequeryhandler.handlequeryexception(exception exception) in c:\dev\cctech main\corp\corp.conveyancing.dataservices\fluentdata.cs:line 4022    @ corp.dataservices.executequeryhandler.executequery(boolean usereader, action action) in c:\dev\cctech main\corp\corp.conveyancing.dataservices\fluentdata.cs:line 3993    @ corp.dataservices.dbcommand.querymany[tentity,tlist](action`2 custommapper) in c:\dev\cctech main\corp\corp.conveyancing.dataservices\fluentdata.cs:line 3857    @ corp.dataservices.dbcommand.querymany[tentity](action`2 custommapper) in c:\dev\cctech main\corp\corp.conveyancing.dataservices\fluentdata.cs:line 3882    @ corp.dashboard.controllers.homecontroller.getinstructionsjson(string id) in c:\dev\cctech main\corp\corp.conveyancing.dashboard\controllers\homecontroller.cs:line 65    @ lambda_method(closure , controllerbase , object[] )    @ system.web.mvc.actionmethoddispatcher.execute(controllerbase controller, object[] parameters)    @ system.web.mvc.reflectedactiondescriptor.execute(controllercontext controllercontext, idictionary`2 parameters)    @ system.web.mvc.controlleractioninvoker.invokeactionmethod(controllercontext controllercontext, actiondescriptor actiondescriptor, idictionary`2 parameters)    @ system.web.mvc.async.asynccontrolleractioninvoker.actioninvocation.invokesynchronousactionmethod()    @ system.web.mvc.async.asynccontrolleractioninvoker.<begininvokesynchronousactionmethod>b__39(iasyncresult asyncresult, actioninvocation innerinvokestate)    @ system.web.mvc.async.asyncresultwrapper.wrappedasyncresult`2.callenddelegate(iasyncresult asyncresult)    @ system.web.mvc.async.asyncresultwrapper.wrappedasyncresultbase`1.end()    @ system.web.mvc.async.asyncresultwrapper.end[tresult](iasyncresult asyncresult, object tag)    @ system.web.mvc.async.asynccontrolleractioninvoker.endinvokeactionmethod(iasyncresult asyncresult)    @ system.web.mvc.async.asynccontrolleractioninvoker.asyncinvocationwithfilters.<invokeactionmethodfilterasynchronouslyrecursive>b__3f()    @ system.web.mvc.async.asynccontrolleractioninvoker.asyncinvocationwithfilters.<>c__displayclass48.<invokeactionmethodfilterasynchronouslyrecursive>b__41()

now peculiar part.
when execute same exact sql directly pl/sql works fine
enter image description here

what going on? there aren't casts in statement. must missing obvious here.

you can't pass in parameter in way. when that, render sql this:

where productid in ('1,2,3,4,5')

which attempt cast value single string number. instead can either:

  • pass values array using table valued parameter. i've not done before pretty sure it's possible, example how use array/table parameter oracle (odp.net 10g) via ado.net/c#?)
  • forget using parameters , use string concatenation. not great idea (sql injection etc.) simple do. validate input regex (and assuming don't have spaces between numbers) use match input (slightly modified comment @liufa): ^[0-9][\,0-9]*$

Comments

Post a Comment

Popular posts from this blog

matlab - "Contour not rendered for non-finite ZData" -

-
i'm trying plot frequency characteristic equation using ezplot, matlab gives following warning, "contour not rendered non-finite zdata". have used command plot frequency equations warning , plot display empty , not change axis range well. can please help. appreciated. here's code i'm using. % transfer matrix case-i, thin rotor clear all; clc; ei = 1626; l = 0.15; m = 0.44108; = 2.178*10^-4; i_p = 2.205*10^-5; itr = 0.24; i_pr = 0.479; syms p n; f = [1 l*1i l^2/(2*ei)*1i l^3/(6*ei); 0 1 l/ei -l^2/(2*ei)*1i; 0 0 1 -l*1i; 0 0 0 l]; p = [ 1 0 0 0; 0 1 0 0; 0 -it*p^2+i_p*n*p 1 0; -m*p^2 0 0 1]; p_r = [1 0 0 0; 0 1 0 0; 0 -itr*p^2+i_pr*n*p 1 0; -m*p^2 0 0 1]; = f*p*f*p*f*p*f; b = p_r*f*p*f*p*f; r = a(1,2)/a(1,4); a12_p = 0; a22_p = a(2,2)-r*a(2,4); a32_p = a(3,2)-r*a(3,4); a42_p = a(4,2)-r*a(4,4); ap(2,2) = a22_p; ap(3,2) = a32_p; ap(4,2) = a42_p; ap(4,4) = 1; c = b*ap; m = [c(3,2) c(3,4); c(4,2) c(4,...
Read more

delphi - Indy UDP Read Contents of Adata -

-
i using indy udp server read string of data. however, not know how work adata parameter. can around converting binary using bytetobin function below , convert hex using bintohex1 . feel stupid , works slow. know how can directly results without 2 conversions? thanks!! here codes: procedure tform1.idudpserver1udpread(athread: tidudplistenerthread; const adata: tidbytes; abinding: tidsockethandle); var buf: tidbytes; buffer: string; data_received: string; begin if bytestostring(adata) <> 'hello' begin buffer := hextostring('00'); setlength(buf, length(buffer)); copytidstring(buffer, buf, 0); abinding.sendto(abinding.peerip, abinding.peerport, buf); data_received := bintohex1(bytetobin(adata[1]) + bytetobin(adata[2]) + bytetobin(adata[3]) + bytetobin(adata[4]) + bytetobin(adata[5]) + bytetobin(adata[6]) + bytetobin(adata[7]) + bytetobin(adata[8]) + bytetobin(adata[9]) + bytetobin(adata[10]) + bytetobin(adata[11...
Read more

qt - How to embed QML toolbar and menubar into QMainWindow -

-
i using qwt library plot data. seems not possible embed qwidget qml quick 2 . so, decided create qmainwindow main window , create toolbar , menubar using quick controls . how should embed qml toolbar , menubar qmainwindow ? you should create qml applicationwindow qml menubar , toolbar main.qml applicationwindow { visible: false menubar: menubar { menu { title: "edit" menuitem { text: "cut" } } } toolbar: toolbar { row { anchors.fill: parent toolbutton { iconsource: "1.png" } } } } main.cpp qapplication app(argc, argv); qqmlapplicationengine engine; engine.load(qurl(qstringliteral("qrc:///main.qml"))); then pointer applicationwindow qwindow *qmlwindow = qobject_cast<qwindow*>(engine.rootobjects().at(0)); create window container, using qwidget::createwindowco...
Read more