Call oracle Stored Procedure with out cursor

Topics: Data Access Application Block
Jun 3, 2008 at 11:04 PM
Hi, is posible to call a stored procedure (oracle) like this: (with out using the cursor trick? )

Procedure testProc (p_TCONX_CDG IN NUMBER,
                               out_server out varchar2 ) as
begin
   SELECT  tbdto.TBDTO_NMB_FISICO_SERVIDOR
                into out_server
        FROM  tconx,
              tsivi,
              tserv,
              tbdto,
              tbl_tipo_base_dato
        WHERE
              tconx.tconx_cdg = tconx.TCONX_CDG AND
              tsivi.TSIVI_CDG=tconx.TSIVI_CDG AND
              tserv.TSERV_CDG=tconx.TSERV_CDG AND
              tbdto.TBDTO_CDG=tconx.TBDTO_CDG  AND
              tbl_tipo_base_dato.TTPBD_CDG = tbdto.TTPBD_CDG and
              tconx.TCONX_CDG = p_TCONX_CDG;
end;


Thank!
Mabc