oracle10g - Using Parameters with Oracle Packages. ODP .NET -


I have an oracle function which returns the record set. I have introduced the parameters for the Oracle function and it is creating front-end code to go to the hardware.

Here is my front-end code. 

  OracleCommand od = oc.CreateCommand (); Od.CommandType = System.Data.CommandType.Text; Od.CommandText = "Select from table * (pkg_fetchPOInfo.getPorowsTable (: 1 ,: 2))"; //od.CommandText = "pkg_fetchPOInfo.getPORowsTable"; //od.CommandType = System.Data.CommandType.TableDirect; OracleParameter op1 = new OracleParameter (); Op1.ParameterName = "1"; Op1.OracleDbType = OracleDbType.Varchar2; Op1 Direction = System. Data Parameter Direction Input; Op1.Size = 6; Op1.Value = strponumber; Od.Parameters.Add (OP1); OracleParameter op2 = New OracleParameter (); Op2.ParameterName = "2"; Op2.OracleDbType = OracleDbType.Varchar2; Op2 Direction = System. Data Parameter Direction Input; Op2.Size = 3; Op2.Value = "US"; Od.Parameters.Add (op2);

If I execute the query in front-end SQLPLUS, then I get a record. This code works if I remove the parameter from the package and front-end code.

Select * From table (pkg_fetchPOInfo.getPORowsTable ('1007446', 'US')); - Works in SQLPLUS.

Select * From table (pkg_fetchPOInfo.getPORowsTable ()); - Works in both places.

Am I specifying the parameter incorrectly?

Package definition: 

  Create package test as function testpipe (NR in number, NR2 in number) or go to the pipeline; End test; Prepare or replace package test PP in the form of Prison TestPIPC as a Period of Period Test (number in number, number in NR2 number) and choose Level of Level and Lieutenant; NR .; Vtt varchartabletype; Open BEGIN TESTPIPE_cur; Loop Fetch testpipe_cur bulk Vtt LIMIT assembled in NR2; Vtt.COUNT loop pipeline for indux in 1 (vtt (indx)); End loop; Pass the exam when testpipe_cur% NOTFOUND; End loop; End testpip; End test;

.NET code: 

  public static zero pipette () {string conString = GetConnectionString (); OracleConnection _conn = new oracle connection (conString); _conn.Open (); Oracle Commands OCMD = New Oracle Commands (); OCmd.CommandText = "Start Open: Select from the table * CRS (testp.testpipe (: nr,: nr2)); end;"; OCmd.CommandType = CommandType.Text; OCmd.Connection = _conn; OracleParameter crs = new OracleParameter (); Crs.OracleDbType = OracleDbType.RefCursor; Crs.Direction = Parameter Direction. Output; Crs.ParameterName = "crs"; OCmd.Parameters.Add (CRS); OracleParameter nr = New OracleParameter (); Nr.OracleDbType = OracleDbType.Int64; Nr. Direction = Parameter Direction. Input; Nr.ParameterName = "nr"; Nr.Value = 25; OCmd.Parameters.Add (NR); OracleParameter nr2 = new Oracle parameter (); Nr2.OracleDbType = OracleDbType.Int64; Nr2. Direction = Parameter Direction. Input; Nr2.ParameterName = "nr2"; Nr2.Value = 10; OCmd.Parameters.Add (NR2); (Using OracleDataReader MyReader = oCmd.ExecuteReader ()) {int columnCount = MyReader.FieldCount; // Get data and add row (MyReader.Read ()) {string s = MyReader.GetOracleValue (0) .ToString (); Console.light line (string.format ("I = {0}", s)); }} Console. Readline (); }

-

Comments

Post a Comment

Popular posts from this blog

Eclipse CDT variable colors in editor -

I hope this is a good question to ask here. This programming is related, so I thought it would be better than the superuser, so I am using the CDT C ++ Eclipse plugin. I know how the editor changes colors for some things But is there a way to do that all the variables are different colors? For example in KDEValue, it sets the local variables and square variables in different colors and bold square squares. Can I copy it to CDT? Eclips provides some level of color customization for text editor syntax You can see it on the following: There are many elements, including the Window> Preferences> C / C ++> Editor> Syntax color code that can be changed, assembly, Comments, Preprocessor and Doxian Under the code, it is possible to change the color of some variable types, such as global variables, local variable announcements, local variable references, and parameter variables. But I do not think the code is capable of changing the color of each variable declared....
Read more

AJAX doesn't send POST query -

$ (दस्तावेज़) .ready (function () {function ajaxselectrss (rssurlvar) {var ajaxRequest; // वेरिएबल जो अजाक्स को संभव बनाता है! कोशिश करें कि {// ओपेरा 8.0+, फ़ायरफ़ॉक्स, सफारी अजाक्स अनुरोध} = नया एक्सएमएलएचटीपीआरइवेस्ट ();} कैच (ई) {// इंटरनेट एक्सप्लोरर ब्राउज़र्स {ajaxRequest = new ActiveXObject ("Msxml2.XMLHTTP");} पकड़ो (ई) {try {ajaxRequest = new ActiveXObject ("Microsoft.XMLHTTP");} कैच (ई) {// कुछ गलत चेतावनी ("आपका ब्राउज़र तोड़ दिया!"); वापसी झूठी;}}} // एक बनाएं फ़ंक्शन जो सर्वर से भेजे गए डेटा प्राप्त करेंगे ajaxRequest.onreadystatechange = function () {if (ajaxRequest.readyState == 4) {var ajaxDisplay = document.getElementById ('news'); ajaxDisplay.innerHTML = ajaxRequest.responseText;}} / / Var rssurlvar = $ (this) .attr ("title"); var queryString = "rurl =" + rssurlvar; var urltofile = "rssget.php"; ajaxRequest.open ("पोस्ट", urltofile, सच); ajaxRequ Est.setRequestHeader ("सामग्री-प्र...
Read more

wpf - Custom Message Box Advice -

Well, I'm using a custom window box that comes with some custom control boxes that accompany the text The producers who are displayed are called. I have a defined event, which has been subscribed through the original class, it gets burnt when clicking on the button. However, I can not see how to use it effectively, I would like to return one yes, whether yes or not, but obviously my code will continue to execute, so this Below is some example code to clarify the problem that the method has subscibed by clicking on the button. Message box window Public partial class custom message box: window {public representative message messagebox object sender, event events e); Public event messagebox handler messagebox document; Public Customs Box () {Initial group (); } Public Customsbox (String Message) {InitializeComponent (); This.txtdescription.Text = Message; } Public Customsbox (String Message, String Title, String First BTNtext) {Initialization (); This.lbltitle.Content =...
Read more