Re: Pro*C access to table of ... components via SQL*Net

From: Ondrej 'Andy' Brablc <brablc_at_my-dejanews.com>
Date: Wed, 05 May 1999 14:53:18 GMT
Message-ID: <7gpm0t$jiu$1@nnrp1.dejanews.com>

In article <01be964b$011c5460$190114c1_at_sister.grant.UUCP>,   "Alexander I. Doroshko" <aid_at_grant.kharkov.ua> wrote:
> With ProC 2.2.3 and Oracle 7.3.4 it works.
> Haven't you tried to rename the Count variable?

I have ProC 2.2.4 and Oracle 8.0.4.2.1 as a remote database. I tried to rename it and to simplify the problem as much as possible. So here it is again. I have this package on remote database

CREATE OR REPLACE Package IFO0018 IS
type t_rec_Currency is record
(

   Currency     varchar2(3),
   Country_name	varchar2(35)

);
type t_tab_rec_Currency is

        table of t_rec_Currency index by binary_integer; END;
/

And I'm trying to compile this program:

char * connect_string="user/demo_at_site";

EXEC SQL INCLUDE SQLCA; main(int argc, char ** argv)
{

   EXEC SQL CONNECT :connect_string;
   EXEC SQL EXECUTE

      declare
         rec_currency IFO0018.t_tab_rec_Currency;
      begin
 	 rec_currency(1).Currency := 'CZK';
	 rec_currency(1).Country_name := 'CZECH REPUBLIC';
 	 DBMS_OUTPUT.put_line(rec_currency.COUNT);
      end;

   END-EXEC;
   EXEC SQL COMMIT WORK RELEASE;
}

I now that DBMS_OUTPUT will do nothing, but it is for me the easiest way to use COUNT component of rec_currency. When preprocessing by Pro*C it stops and writes:

PCC-S-02306, wrong number or types of arguments in call to 'COUNT'

The very same thing it will do with LAST or FIRST, NEXT(1) also does not work. But I could even touch rec_currency(1).Currency. And when running from inside "sqlplus user/demo_at_site" it works fine. So it seems to as a bug or some compatibility error.

        Andy

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Wed May 05 1999 - 09:53:18 CDT