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.

I am trying to call Oracle function via Linked Server, while executing it return the error. Can some one tell what is going wrong with this code, keep in mind that the parameter passed are of exactly same type defined in Oracle function except the date type parameter which I am passing as string because there is no equivalent. -- returned error -- OLE DB provider "MSDAORA" for linked server "ERPUDEV" returned message "ORA-06550: line 1, column 18: PLS-00382: expression is of wrong type ORA-06550: line 1, column 7: PL/SQL: Statement ignored -- calling part -- DECLARE @source_code VARCHAR(30) DECLARE @source_lineid INT DECLARE @feeder_itemcode VARCHAR(40) DECLARE @sales_price INT DECLARE @fdr_org_code VARCHAR(10) DECLARE @fdr_subinv_code VARCHAR(10) DECLARE @txn_qty INT DECLARE @txn_date VARCHAR(30) DECLARE @feeder_txntype VARCHAR(30) DECLARE @fdr_subinvcode VARCHAR(10) DECLARE @fdr_trnsubinvcode VARCHAR(10) DECLARE @item_desc VARCHAR(10) DECLARE @ErrMsg VARCHAR(100) DECLARE @RetVal INT SET @source_code = 'SSP-SALES' SET @source_lineid = 8728 SET @txn_no = '15059' SET @txn_no2 = '29193' SET @feeder_itemcode = 'SSP1032' SET @sales_price = 12 SET @fdr_org_code = 'S' SET @fdr_subinvcode = 'S-SALES' SET @txn_qty = 1 SET @txn_date = '13/MAR/2010' SET @feeder_txntype = 'S-SALES_ISSUE' SET @fdr_trnsubinvcode = '' EXEC ('BEGIN ? := xx_eginv_f_dfs_erp_insert(?,?,?,?,?,?,?,?,?,?,?,?);END;', @RetVal,@source_code, @source_lineid, @txn_no, @feeder_itemcode, @sales_price,@fdr_org_code, @fdr_subinvcode, @txn_qty, @txn_date, @feeder_txntype, @fdr_trnsubinvcode,@ErrMsg OUTPUT) AT ERPUDEV

The Phantom.

modified on Sunday, March 14, 2010 8:19 AM

I am using NVidia video splitter card to split my windows XP on dual monitors. In configuration I set monitor as primary (left) and the other secondary (right), where I am displaying the windows desktop icons on the secondary monitor and taskbar is limited to the primary monitor. Now I am running my custom applications, where the applications are choosing where to show on their own - some moving to primary and some to secondary, I want to control the application display. If someone knows how to do it, appreciated. Thanks.

The Phantom.

My requirement is to read data from Oracle using BizTalk (XML) and write to SQL Server. Looking for recommendations. Thanks.

The Phantom.

There are two ASP.Net pages. Page-A contains GridView control, whenever user adds a new row or edit existing row can see an image, on click of image a new window pops-up which contains a textbox and a button. Whenever user types something in textbox and presses the button the text should be transferred back to the EDITABLE or NEW Row in GridView in one of the textbox controls. Now the problem is how to do that. Thanks.

The Phantom.

I like to add 10 rows on Page_Load to datagrid where in every column I need different controls (Textbox, Combo Box and Image Control). Help appreciated. Thanks.

The Phantom.

My datagrid is bind with a datasource. Now I need to add a number of rows dynamically to the datagrid, where rows contains controls. How to do this? Help kindly appreciated. Thanks.

The Phantom.

Question with interesting replies. Check out http://channel9.msdn.com/ShowPost.aspx?PostID=182400[^] The Phantom.

Hi all, I am experiencing a problem while running two stored procedures manipulating same table. While SP1 is performing some updation and SP2 tries to read, even SP2 is reading it waits until SP1 gets completed. I have really no idea whats happening. Kindly need your feedback. thanks. The Phantom.

I have created a Web Form (parent), after that I embed a Web User Control using <%@ Register %> directive. Then I have created another Web Form and invoking this as a child. Now I am trying to pass a value back to parent. Problem is if I pass this to some control outside the Web User Control using javascript its passing correctly and I am able to see the passed value; but If pass to some control inside Web User Control using same javascript it won't. This problem can easily visualize through this sketch. [PARENT] [FORM] [HTML CONTROL][/HTML CONTROL] [WEB USER CONTROL] [HTML CONTROL][/HTML CONTROL] [/WEB USER CONTROL] [/FORM] [/PARENT] I am sure there must be some way to solve out. Need help. The Phantom.

In Tab Control the Tab Dialogs change their position automatically whenever I do a change. Sometimes they change at design time and sometimes at runtime. A very strange behaviour I am experiencing. Help required.:( The Phantom.

.NetFoundry pleased to announce the launch of its usergroup website.The user group member will have inside access to information and training on the new products from Microsoft. Plus all usergroup member are part of upcoming Visual Studio and SQL Server 2005 activities. Even if you are not a usergroup member you still have an oppertunity to partiticipate in discussion forums, article submission and much more. Related link: http://v900u039rux.maximumasp.com/Web/[^] The Phantom. -- modified at 7:58 Saturday 14th January, 2006

I have a requirement of Outlook integration in my C# Desktop application. I tried the Outlook .Net Connector on CP. I changed the Outlook reference to Outlook 10.0, it run smoothly but whenever I tried to get the inbox mails, it always show one message with repition, instead of showing every message. Could any one help me out. Thanks. The Phantom.

Hi, I want to get all of my inbox messages in to my application using C#. If their is any code snippet you have please share it. Help kindly appreciated. The Phantom.

Hi, My requirement is to do a file copy (upload) from my machine to a remote machine (Mapped Drive) both windows and at the same time I want the file copying logic should completely reside on my machine, I donot require peer2peer. Is their any way to do that, help kindly appreciated. The Phantom.

I am trying to input \n\n in my query while running an INSERT query, but MS Access if not allowing me to do so, at the same time it doesn't allow me to pass single quote into the query. Any body know how to resolve it and how to deal with this kind of situation. The Phantom.

Hi, I have five textboxes, where each of them defined as txtControl1 to txtControl5. Now I am running a loop to populate these textboxes with some text like this for (i=1; i<6; i++) { txtControl+i.Text = "Hello World" ; } Now when I am compiling, I am getting error "unable to find txtControl", with error message its clear the above line is unable to contact the control with the value of i. Is anyone know how to do that :confused: The Phantom.

Yokon... .Net ... what else you require. Is .Net enabling the SQLServer is the most blasting feature MS ever provide? some details found on this link : .Net Foundry/Yokon-.Net-whatelse The Phantom.

Jeremy, I really like your defensive mode :) Really, really appreciate to all of them who are participating to discuss this post. I really appreciate Corrina's efforts after looking into her file, at least now I know that if you say something they ;) will yell. If Corrina look into my profile, SHE (at last ... a sigh) must oversee that I am an old member. I said two things, one was related to my circle where I am physically working and the other is the internet. While doing some thing when on the internet bandwagon, there is not much enough time to figure out who is who. IMO, the CP articles must contain one more thing which says, "This article was written by a FEMALE" ;) Cheers, The Phantom.

I am an unofficial Microsoft .Net Evangelist, whose job is to put the efforts into the advancement of this smashing technology. In my routine work I came across many people who are architects, designers, application programmers, developers and testers, the equality among all of them is all are men. I never heard of any lady in my circle who is keen towards learning or creating something on this new technology created by the famous software giant. I am always in doubt, do ladies don't want to do tough job by adding their efforts, are they become tired to shift from one technology to the other. Their is a hype that still men is able to perform well and always take the challenge. Whenever I read the articles, tutorials from MSDN, MSJ, TheServerSide.Net, GotDotNet, CodeProject they all have one thing in common, ladies are not allowed, this doesn't mean that website owners are stopping them to do, instead they are not taking challenge to do something which appeals or which create some attraction towards the men crowd on this planet internet. I am always in search of good ladies who willingly wants to take the challenge on the same ground as do I, but I am unable to find any one, again this doesn't mean I myself is considered but one has to look into this that very few of them are working on this challenging platform, not most of them. I always appreciate work from a lady on the architect level, afterall they have somewhat creativity to create new things, instead of putting their efforts to craft something on this domain, they put it in the cosmetic work. I hope in the future more and more ladies come towrds creating something on this platform, like the men do and I am happy to collect arguments on this. To read in detail logon to http://netfoundry.blogspot.com/ Thanks. -Danish Sami 09:00 15/09/2004 The Phantom.