Crystal and Oracle8 Stored Proc

[teddyboy]

Can anyone show me how to construct an Oracle SP passing up to 9 paramenters and returning multiple lines/columns. What tools do you use? How do you complie the SP? [sig][/sig]

 

[emallon]

I used VB6 to create a DLL and embedded the call to the stored procedure in the DLL code. The VB6 procedure in the DLL then appears as a function in SCR8. Then, you simply create a formula using the function in from your DLL and execute your stored procedure. Your stored procedure doesn't need compiling except during creation. Your stored procedure could populate a table to return as much data as you need. The parameters to pass in can be SCR8 parameters in your report that can be passed to the stored procedure through the function call.