asp.net - ODP.NET VB.Net calling a stored procedure and returning a refCursor -

asp.net - ODP.NET VB.Net calling a stored procedure and returning a refCursor -

Text after "

This problem has driven me crazy more than a day now. I can make a connection to the database, I execute SQL and that's the result in itself, but I can not seem to call a stored procedure. Here is the code

  New MyCMD as the new OracleCommand Dim TheDataReader as new OracleDataReader myConnection1.Open () myCMD.Connection = myConnection1 myCMD.CommandType = CommandType.StoredProcedure myCMD.CommandText = "WS_DATA_LAYER .select_user_groups "myCMD.Parameters.Add (new OracleParameter (" id_user ", OracleDbType.VarChar2)). Value = "Txa" myCMD.Parameters.Add (new OracleParameter ("ws_rs", OracleDbType.RefCursor)). Direction = ParameterDirection.Output 'has tried every single execution function and none of the work is done here' either error thrown or empty refresher myCMD.ExecuteScalar () TheDataReader = myCMD.Parameters (1) .Value () GetDataReader ()    At this time, the problem lies in the execution slaler. It is throwing an exception that was called "the input string was not in a correct format". I tried to cross the string with the Oracle single quotation marks and get the same thing if I use  
  TheDataReader = myCMD.ExecuteQuery ()   < P> It works fine but no results are given. I have verified that as a result of this process, I give results for the user in which I am logged in. When the query was being executed, I could see a refresher there but it was empty. I should be crazy   Any help is appreciated   
 
  This problem is, I The VB method was passing OracleDBType.Varchar2 as the parameter. But I had declared it as an integer, it obviously needs to be passed as an OracleDBType   

 


  






03:22

















Get link





Facebook





X





Pinterest





Email





Other Apps




Comments





Post a Comment







Popular Posts









r - Plot correlation matrix into a graph -



    I have a matrix with some correlation values. I now want to plot in that graphic which is more like this or Looks less:         Library (Latis) # Horizontal and vertical axis information please take- c (div class = "post-text" itemprop = "text">  "214", "215", "216", "224", "211", "212", "213", "223", "226", "225") & lt; - Paste ("DM1- ", Hor, sep =" ") # counterfeit co Relation matrix narokol & lt; (I 1: nrowcol) for core [i] - length (var) core & lt; - matrix (runif (nrowcol * nrowcol, min = 0.4), nrow = nrowcol, ncol = nrowcol (Color, "blue", "yellow"), space = "RGB"), levelplates (core, main = "dimnames = list (hor, ver)), I] = 1 # plot rgb. Stage 12-14 array correlation matrix ") Xlab =" ", ylab =" ", col.regions = rgb.palette (120), cut = 100, at = seq (0,1,0.01)) ...






asp.net - RegisterUser: CreateUserWizardStep -



    When using CreateUserWizardStep to register a new user I'm having a problem.   Help me solve this problem.I have tried to configure in the web. Provider tag for configuration    & lt; Required question and answer = "wrong" & gt;    Although it still does not work ... I'm using the MySQL database    RegisterUser :. An IEditableTextControl is not included with the CreateUserWizardStep.ContentTemplate ID question for the security question, it is necessary that your membership provider needs a question and answer.   Source error:   An unrestricted exception occurred during the execution of existing web requests. Information about the origin and location of the exception can be identified using the exception stack trace below.   Stack trace:.   [HttpException (0x80004005): RegisterUser: CreateUserWizardStep.ContentTemplate does not include questions IEditableTextControl security question with the ID, it is necessary to require a question and answer your subscri...






Integrate flash games in android app? -



    3 is a flash game that I want to integrate into a menu / list in the Android app. So when the user selects the game from the list, the game starts with the help of the Android Flash Player.   Is it better or better with webwave?   Is there any good tutorial?   Thank you! Adobe Flash provides a good way: you can create a breeze for the Android app.    Use this to create your menu and compile three games in your air app.   Here are some tutorial links about how to publish AiI for Android applications and:   PART1: AIR for Android, PART2:   Publication for Android apps: Ai:   I do not believe that the Android Flash Player can be launched with a single intention so far, so using Java Android will not solve it (now ) And   and a third approach Whatever you mentioned, it should work - using the webwave.








Powered by Blogger