How do I pass a DYNAMIC RESULT SET back to Visual Basic ?
I see that a stored procedure can pass a cursor back to a calling application by using a DYNAMIC RESULT SET. My calling app is Visual Basic, and I can not find any info on how to do this from the VB side. An Oracle stored procedure passes back a reference to the cursor by using a stored procedure OUT parameter, and the VB code can reference it as shown below.
But how does a Teradata stored procedure give the name of the cursor to VB ? The clip below (from the TD Stored Procedure manual) opens the two cursors, but I dont see any mechanism to pass them back to the caller. Can someone point me to any examples of how to do this? Thanks!