Thanks for the comments. A little more to understand the problem, I'v found that the error message was because of the returned type boolean (@RetVal). -- oracle implementation --====================== CREATE OR REPLACE FUNCTION TEST_ERP_INSERT ( P_SOURCE_CODE IN VARCHAR2 , P_SOURCE_LINE_ID IN NUMBER , P_TRANSACTION_NUMBER IN VARCHAR2 , P_FEEDER_ITEM_CODE IN VARCHAR2 , P_SALES_PRICE IN NUMBER , P_FEEDER_ORGANIZATION_CODE IN VARCHAR2 , P_FEEDER_SUBINVENTORY_CODE IN VARCHAR2 , P_TRANSACTION_QUANTITY IN NUMBER , P_TRANSACTION_DATE IN VARCHAR2 , P_FEEDER_TRANSACTION_TYPE IN VARCHAR2 , P_FEEDER_TRANSFER_SUBINV_CODE IN VARCHAR2 , p_errmesg OUT VARCHAR2 ) RETURN BOOLEAN IS BEGIN RETURN 1; -- EXCEPTION -- WHEN OTHERS THEN -- p_errmesg := 'Error:' || SQLERRM; -- RETURN 0; END; -- calling from sql server --======================== DECLARE @ErrMsg VARCHAR(1000) DECLARE @RetVal SMALLINT EXEC ('BEGIN ? := TEST_ERP_INSERT(?,?,?,?,?,?,?,?,?,?,?,?);END;', @RetVal,'SSP-SALES', 8728, '15059', 'SSP1032', 12,'S', 'S-SALES', 1, '13/MAR/2010', 'S-SALES_ISSUE', '', @ErrMsg OUTPUT) AT ERPUSTG; Any idea? I can't change the returned type because its a different system. The Phantom.

Are you wanting to do this with code or just have them be in the right monitor when they open? If it's the latter simply move them to the monitor you want them in by dragging and when you close them they will save that position for when you reopen them. ATI video cards come with Hydravision and it lets you do some pretty cool stuff to your windows and it has support for [SETTING] windows position and keeping it there. Nice product and free.

Ph@ntom wrote: My requirement is to read data from Oracle using BizTalk (XML) and write to SQL Server. Why? You can do this by reading the data from SQL Server using SSIS (SQL Server Integration Services) which is perfectly capable of transforming data from other database sources. Deja View - the feeling that you've seen this post before. My blog | My articles

Use tables.insert ten rows and add the table into the datagrid.

You can have a look at this article: http://www.vbdotnetheaven.com/Code/Jul2003/2134.asp[^] :) Best Regards, Apurva Kaushal

Well its prolly because your going inside a container( the Web User Control ) View the source from IE and find out the name of the container. Then find the control from the container in javascript 1 line of code equals many bugs. So don't write any!!

Just as a hint: Before posting here at least search Google and the article base here on CodeProject. Now to the answer: This article should contain all you need.

You can use two FileStreams. One for reading from the source file and the second for writing to the mapped drive. Have a look at System.IO.File.OpenRead and System.IO.File.Create for getting the streams.

You will not be able to convert i (which is int variable) to first a string variable, and then a string variable to a textbox. Better way to do so is to declare an ArrayList (say called arrayTextBoxes). Then, initialize this ArrayList in the constructor of the form on which the textboxes are placed. You can declare the initial capacity of this ArrayList (which defaults to 16). Thereafter, (in the constructor of the form itself) populate the ArrayList with the instances of the 5 textboxes being used by you, by using the Add or AddRange method. Now you are ready to use the members (i.e., the textboxes)of the ArrayList in your code as, for example,- for (i=0; i<5; i++) { //here the arrayList is 0-based, so use i = 0 onwards ((TextBox) arrayTextBoxes[i]).Text = "Hello World" ; //arrayTextBoxes is the aforesaid ArrayList instance } In the aforesaid example, arrayTextBoxes[0] will represent the textbox1, and so on.

You know what we do to smart alecs, don't you? Keep giving them material to work with? ;) -- Russell Morris "So, broccoli, mother says you're good for me... but I'm afraid I'm no good for you!" - Stewy

Thanks :) It is a wonderful pastime, and it's good to meet others who share the same passion! Look at the world about you and trust to your own convictions. - Ansel Adams Meg's World - Blog Photography