Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Converting SQL Anywhere stored procedures to ORACLE for use with Powerbuilder

Converting SQL Anywhere stored procedures to ORACLE for use with Powerbuilder

From: Gary Corless <gary.corless_at_celtic.eureko.ie>
Date: Tue, 12 May 1998 10:10:38 +0100
Message-ID: <6j98gu$vbd$1@news2.news.iol.ie>


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 Tue May 12 1998 - 04:10:38 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US