Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Converting SQL Anywhere stored procedures to ORACLE for use with Powerbuilder
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