REPOST: Calling a package within VB

From: Carlos Alberto <calberto2312_at_hotmail.com>
Date: 28 Dec 2001 11:31:50 -0800
Message-ID: <9$--$$_--%%_--$$_$@news.noc.cabal.int>

Hi,

   I want to return a result set from a package inside a VB code, using OLE DB. The package is as follows :

Definition of the package :

  TYPE CURSOR_PARAMETRO IS REF CURSOR;
  Procedure sp_LeerParDefTodas

( i_tipoparametro varchar2 ,

          o_retorno       out number,
          o_mensaje     out varchar2,
          P_CURSOR       OUT CURSOR_PARAMETRO);

...

Definition of the package body :

        Procedure  sp_LeerParDefTodas


        ( i_tipoparametro varchar2 ,

          o_retorno       out number,
          o_mensaje     out varchar2,
           P_CURSOR       OUT CURSOR_PARAMETRO)
        as
        Begin
               o_retorno := 0;
               o_mensaje := 'Ok';

        OPEN P_CURSOR FOR               
               select   *
               from      pardef
                where     DEF_TIPPAR = i_tipoparametro
                  and     def_estado <> 'E'
                order by def_codalf ;

               if SQLCODE <> 0 then     
                o_retorno := SQLCODE;
                o_mensaje := SQLERRM;
               end if;

        End sp_LeerParDefTodas;

Here´s the connection with the database :

Con.ConnectionString = "Provider=OraOLEDB.Oracle;Password=" & Password & ";Persist Security Info=True;User ID=" & UserName & ";Data Source=" & DataSource & ";PLSQLRSet=1"  

   The owner of the package is 'proyecto'. When I run the VB application logged as proyecto, it works fine, but when I run with other Oracle user (with the permissions correctly defined), I receive the following error :

PLS-00306: wrong number or types of arguments in call to 'SP_LEERPARDEFTODAS'    Any ideas?

Thanks in advanced,
Carlos

• WAS CANCELLED BY =======: Message-ID: <cancel.72954535.0112281131.301481b1_at_posting.google.com> Control: cancel <72954535.0112281131.301481b1_at_posting.google.com> Subject: cmsg cancel <72954535.0112281131.301481b1_at_posting.google.com> From: calberto2312_at_hotmail.com (Carlos Alberto) Newsgroups: comp.databases.oracle.misc X-No-Archive: yes Lines: 2 NNTP-Posting-Host: wonenara.ozemail.com.au X-Trace: ozemail.com.au 1009694864 203.108.164.177 (Sun, 30 Dec 2001 17:47:44 EST) NNTP-Posting-Date: Sun, 30 Dec 2001 17:47:44 EST Organization: OzEmail Ltd, Australia Distribution: world Date: Sun, 30 Dec 2001 06:26:25 GMT Path: news.sol.net!spool0-nwblwi.newsops.execpc.com!newsfeeds.sol.net!news-out.visi.com!hermes.visi.com!news1.optus.net.au!optus!yorrell.saard.net!duster.adelaide.on.net!newsfeed.ozemail.com.au!ozemail.com.au!not-for-mail

This message was cancelled from within Mozilla. Received on Fri Dec 28 2001 - 13:31:50 CST