Questions on stored procedure invoke when use DAS

[raozhl/Rao Zhenlin(IT)]

Dear Sir or Madam,
 I'd like to know if DAS can fetch resultsets which are returned from 
stored procedure via temp table
 
for example:
 
 CREATE PROC A
 AS
 CREATE TABLE #TMP(
   NAME VARCHAR(30)
 )
 
 INSERT INTO #TMP VALUES('MICHAEL')
 
 SELECT USER_ID FROM REALTABLEA
 
 SELECT NAME FROM #TMP
 
when I use das.executequery() to invoke the stored procedure,I can only get the 
"REALTABLEA" objects list from root DataObject, and it seems that the results 
in #TMP( temp table )can not be converted into DataObject
 
I am wondering if there is a way to fetch the data returned in temp table as 
well as real tables?
 
Any idea?
Thank you very much!
 
Mike Rao
 



DISCLAIMER:
This e-mail is confidential for COSCO CONTAINER LINES (COSCON) and may also be 
privileged. Any unauthorized use, copying, or dissemination of it and any 
attachments to it, is prohibited. If you have received this e-mail in error, 
please delete it immediately, unread and notify the sender as soon as possible. 
COSCON does not warrant this email is virus-free and is not liable for any 
losses or responsibilities arising from any virus being transmitted by this 
email. Internet communications are not secure and COSCON does not accept legal 
responsibility for the contents of this message.

Re: Conversational webservices not supported yet?

[Raymond Feng]

FYI:

Luciano has already implemented the feature to parse the SCA extended 
attributes in WSDL and popluate the model.


Thanks,
Raymond
--
From: "Sun Yang" <[EMAIL PROTECTED]>
Sent: Tuesday, June 03, 2008 5:42 PM
To: 
Subject: Re: Conversational webservices not supported yet?


Hi, Raymond:

I am very interested in this area. I will start this work after a 8-days 
SAP

commercial training (till June. 12).

Best Regards,
Yang Sun


2008/6/3 Raymond Feng <[EMAIL PROTECTED]>:


Hi,

You are right. We haven't implemented the logic to check the SCA 
extensions

in WSDL. Are you interested in helping out?

Thanks,
Raymond
--
From: "Sun Yang" <[EMAIL PROTECTED]>
Sent: Sunday, June 01, 2008 4:54 AM
To: 
Subject: Conversational webservices not supported yet?


 Hi, all:


I want to create a prototype which simulate a j2se client connecting to 
a

SCA domain using web services conversationally.

I mark the interface as @Conversational, and to support the conversation
feature, I add the "sca:requires=conversational" to the wsdl port type.
The sca running trace always complains that it cannot find the 
component.


I make some debugging and find the reason is that Tuscany cannot
introspect
the wsdl interface as conversational. I go some deeper to
WSDLInterfaceIntrospectorImpl.introspectPortType(). I see the following
code
:
  // FIXME: set to Non-conversational for now
  wsdlInterface.setConversational(false);

It seems that tuscany doesn't support conversational for the wsdl
interface.
Is that correct or could I make some modifications to make it support
conversational.

Any comments are welcomed.

Best Regards,
Yang Sun