Re: How to fire a stored proc from a query window

Lee wrote:
> Frank
>
> Thanks for the info. The VarChar thing was a typo in the sample and
> the "Omwb" was copied from another sp that did come from the
> Workbench. We have since found out the "Non Workbench" method of
> using and refering to them in the proc.
>
> The whole problem from the original post was how to call the proc and
> get the returned Ref Cursor back and display the results.
>
> Actually at this point we still have not figured it out. Doing this
> same thing is a MS SQL world is very simple becuase the result sets
> (or record sets) are returned by default.
>
> Thanks
> Lee
>

Don't know about DBArtisan, sorry. In an SQL session it would be as simple as:

SQL> var r refcursor
SQL> set autoprint on
SQL> begin SA.USP_LEES_TEST_SP (strAgentCode => 'H10', RC1 => :r); end;

-- 

Regards,
Frank van Bortel