I haven't tried it, but I am thinking that since stored procedures are
stored in the database, if you try disconnecting and connecting to another
database, I think you will have some problems. Now, if the secondary
database is already Sconnected to your database and the table is attached,
you should be able to access it through your stored procedure.
I know I can access other non R:base datasources from R:tango this way. I
have not tried it through a stored procedure, but once the table is
attached, it shouldn't matter how you access it.
Troy Sosamon
===== Original Message from [EMAIL PROTECTED] at 9/23/02 8:52 am
>Hi Bill,
>
>We'll explore sp... I like the idea of possibly being able to combine
>several tango dbms into a single stored procedure.
>
>Will post anything interesting.
>
>Thanks
>Brent
>
>
>
>
>
>
>
>-----Original Message-----
>From: Bill Downall <[EMAIL PROTECTED]>
>To: Multiple recipients of list witango-talk <[EMAIL PROTECTED]>
>Date: Monday, September 23, 2002 7:34 AM
>Subject: Re: Witango-Talk: Stored Procedures
>
>
>On Sun, 22 Sep 2002 16:47:33 -0700, Brent Skean wrote:
>
>>Can a stored procedure as you describe be used to pull in data from
>>a variety of datasources, simply using Connect db's and sel's.
>>ie, set up the dbms with some datasource... then, can the stored
>>procedure connect to other local rbase db's and pull data... thereby
>>ending up with an array with data from disparate datasources?
>
>Brent,
>
>An added note to what I said before: The SP cannot interact with your
>Witango variables or arrays directly, only through the parameterlist
>going to the SP, and in the result set or any other output files created
>by the SP.
>
>Bill
>
>
>
>
>
>
>________________________________________________________________________
>TO UNSUBSCRIBE: send a plain text/US ASCII email to [EMAIL PROTECTED]
> with unsubscribe witango-talk in the message body
>
>
>________________________________________________________________________
>TO UNSUBSCRIBE: send a plain text/US ASCII email to [EMAIL PROTECTED]
> with unsubscribe witango-talk in the message body
________________________________________________________________________
TO UNSUBSCRIBE: send a plain text/US ASCII email to [EMAIL PROTECTED]
with unsubscribe witango-talk in the message body
