Re: Converting SQL Anywhere stored procedures to ORACLE for use with Powerbuilder

No, you can't.

Oracle's stored procedure do not return result set as simple as Sybase's ones.
If you want to use sp for this simple code (which I would not anyway) , read about PBDBMS package that comes with powerbuilder.

Yakov Fain

Gary Corless wrote:

> We currently are using SQL Anywhere stored procedures to return data to
> powerbuilder and we are trying to moving over to ORACLE 7.3.3. Can we
> convert this code directly to use ORACLE SPs, as DWs are not feasible
>
> SQL AnyWhere SP:
>
> Create or replace procedure sp_GET_County()
> result("Name" char(15))
> begin
> select t1."Name"
> from tbl_County as t1
> order by t1."Name" asc
> end
>
> Powerbuilder code:
>
> Declare lsp_Load Procedure for sp_GET_County Using l_Trans;
> Execute lsp_Load;
>
> Do
> Fetch lsp_Load Into :ll_Id,:ls_Name;
>
> ...
> Loop Until l_Trans.EOF()
> Close lsp_Load;
Received on Wed May 13 1998 - 13:29:10 CDT