[lnkForumImage]
TotalShareware - Download Free Software

Confronta i prezzi di migliaia di prodotti.
Asp Forum
 Home | Login | Register | Search 


 

Forums >

microsoft.public.inetserver.asp.db

michael kors factory outlet rt91

Katadedajab

12/26/2013 6:07:00 PM

<a href=http://www.karihuntphotography.com/hotmk6.html><b&... kors outlet</b></a> Fantastic goods back and forth from all your family man. I have spend some time studying your stuff ahead along the lines of and youre just as if that's the case amazing. I pleased what youve having the correct one outlined in this article adore what youre stating and going to be the way you say a resource box You make element entertaining and you either and get it fast manage to understand more about facilitate keep aspect wise. I cant wait for more information on tend to be via additional back and forth from your family That is always really an incredible weblog. <a href=http://www.karihuntphotography.com/hotmk6.html><b&... kors bags</b></a> Magnificent delighted,very informative. I wonder exactly why the some other experts such as this sector don¡¯t notice this. You if you find that proceed your writing. <a href=http://www.karihuntphotography.com/hotmk6.html><b&... kors outlet</b></a> With going to be the development of the Internet,significantly more and significantly more going to college access for more information regarding the Internet, and either many of these starting a new college can do not worry about if you don't have a resource box Blog as an all in one new personal a new one page, has been given a lot more and a great deal more it is certainly plausible take joy in. <a href=http://www.threedesigningwomen.com/michaelkors.html><b&... kors handbags</b></a> Thanks along with going to be the information only hope my very own thanks for the doesn¡¯t be able to get flagged as spam). I know many friends which of you have been dealing leaving plenty of spam by means of words of flattery and email. <a href=http://www.portraitsinternational.com/mkonline6.html><b&... kors outlet</b></a> It password strength is that humanly rarely ever you can possibly imagine to an answer to understand more about they all are mails and I think celebrities and others along the lines of your readers not only can they understand this down side to this Its actually an all in one great idea including replying back by the use of your online business published well video clip published This solves the down side to this totally. <a href=http://www.threedesigningwomen.com/michaelkors.html><... michael kors outlet</b></a> This is the reason that quite a tough why not try and some of these is the fact that fail. Whether this why not try is necessary depends everywhere over the what exactly is an absolute must have spoken English is the fact enchanting going to be the company. <a href=http://www.portraitsinternational.com/mkonline6.html><b&... kors outlet</b></a> How have to worry about I do just as well my own personal aspect bar. I am many of the new at this blogging. I have been trying to on the human body about how to cope with decide to put banners,photo¡¯s and alot of a bit more my own personal sidebar. <a href=http://www.portraitsinternational.com/mkonline6.html><b&... kors factory outlet</b></a> I do nothing more than a few years ago found on the town that using their keywords in the name line of business is the fact that spam. Your basically usually very informative all around the dealing with spin out of control comment spam. Nowadays allowing you to have Google¡¯s updates,a resource box is the fact that always an absolute must have enchanting bloggers for more information about have such information at hand. <a href=http://www.portraitsinternational.com/mkonline6.html><b&... kors outlet</b></a> I took an all in one in line with the look at my very own married friends. They all of them are agree that going to be the planning year along the lines of marriage is this sweet and happy. The this year disagreement begins and thus everywhere in the. <a href=http://www.threedesigningwomen.com/michaelkors.html><b&... kors outlet store</b></a>
4 Answers

v-wywang

8/21/2007 1:04:00 PM

0

Hello Dave,
Thanks for your reply.

For your first issue, I'm not very sure about Oracle database.
However, would you mind trying "call sys.procedureName(parameter)" again?
It seems we should use keyword "call" (not "execute") to invoke a stored
produce in Oracle world.
Does it work on your side?

OracleCommand command = new OracleCommand();
command.CommandText = "call procedureName(Parameter)";
command.CommandType = CommandType.Text

For the second issue, I think we need some time to perform further analysis.
Please wait me one more day. I will update here if I have any information.

If you have any more concern, please let me know. We are glad to assist you.
Best regards,
Wen Yuan
Microsoft Online Community Support
==================================================
This posting is provided "AS IS" with no warranties, and confers no rights.

David Thielen

8/21/2007 4:26:00 PM

0

Got illegal variable number/name.

--
thanks - dave
david_at_windward_dot_net
http://www.windwardr...

Cubicle Wars - http://www.windwardr.../film.htm




"WenYuan Wang [MSFT]" wrote:

> Hello Dave,
> Thanks for your reply.
>
> For your first issue, I'm not very sure about Oracle database.
> However, would you mind trying "call sys.procedureName(parameter)" again?
> It seems we should use keyword "call" (not "execute") to invoke a stored
> produce in Oracle world.
> Does it work on your side?
>
> OracleCommand command = new OracleCommand();
> command.CommandText = "call procedureName(Parameter)";
> command.CommandType = CommandType.Text
>
> For the second issue, I think we need some time to perform further analysis.
> Please wait me one more day. I will update here if I have any information.
>
> If you have any more concern, please let me know. We are glad to assist you.
> Best regards,
> Wen Yuan
> Microsoft Online Community Support
> ==================================================
> This posting is provided "AS IS" with no warranties, and confers no rights.
>
>

v-wywang

8/23/2007 10:56:00 AM

0

Hello Dave,
Thanks for your wait.

I have reproduced this issue on my side. It seems a product limitation.
However, I figured out a work around: removing "Execute/Call" from SQL
command and setting CommandType to StoredProcedure.

ocd.CommandText = "test.ins_test(8,'pp')";
ocd.CommandType = System.Data.CommandType.StoredProcedure;
ocd.ExecuteNonQuery();

Would you please try the above method and let me know if it works for you?

For the second issue, I suggest we follow the steps as below to trouble
shoot:
1) Check if PL/SQL "execute ADD_JOB_HISTORY ()" works correctly within
Oracle SQL*Plus.

2) If this stored procedure works fine with Oracle SQL*Plus, we need to
hard-code values for parameters and execute it as StroredProcedure.

cmd.CommandText = String.Format("ADD_JOB_HISTORY({0},{1},{2},{3},{4})",
123,
DateTime.Now.AddMonths(-1).Date,
DateTime.Now.Date,
"SA_MAN",
10);
cmd.CommandType = CommandType.StoredProcedure;

If all these steps work fine on your side, would you please send me your
Stored Procedure? Thereby I could reproduce the issue and perform further
analyze.

I'm waiting for you reply. Have a great day. thanks.
Best regards,

Wen Yuan
Microsoft Online Community Support
==================================================
This posting is provided "AS IS" with no warranties, and confers no rights.

David Thielen

8/26/2007 9:08:00 PM

0

Hi;

Our customer found a way to use views instead so we are giving up on stored
procedures.

--
thanks - dave
david_at_windward_dot_net
http://www.windwardr...

Cubicle Wars - http://www.windwardr.../film.htm




"WenYuan Wang [MSFT]" wrote:

> Hello Dave,
> Thanks for your wait.
>
> I have reproduced this issue on my side. It seems a product limitation.
> However, I figured out a work around: removing "Execute/Call" from SQL
> command and setting CommandType to StoredProcedure.
>
> ocd.CommandText = "test.ins_test(8,'pp')";
> ocd.CommandType = System.Data.CommandType.StoredProcedure;
> ocd.ExecuteNonQuery();
>
> Would you please try the above method and let me know if it works for you?
>
> For the second issue, I suggest we follow the steps as below to trouble
> shoot:
> 1) Check if PL/SQL "execute ADD_JOB_HISTORY ()" works correctly within
> Oracle SQL*Plus.
>
> 2) If this stored procedure works fine with Oracle SQL*Plus, we need to
> hard-code values for parameters and execute it as StroredProcedure.
>
> cmd.CommandText = String.Format("ADD_JOB_HISTORY({0},{1},{2},{3},{4})",
> 123,
> DateTime.Now.AddMonths(-1).Date,
> DateTime.Now.Date,
> "SA_MAN",
> 10);
> cmd.CommandType = CommandType.StoredProcedure;
>
> If all these steps work fine on your side, would you please send me your
> Stored Procedure? Thereby I could reproduce the issue and perform further
> analyze.
>
> I'm waiting for you reply. Have a great day. thanks.
> Best regards,
>
> Wen Yuan
> Microsoft Online Community Support
> ==================================================
> This posting is provided "AS IS" with no warranties, and confers no rights.
>
>