Agfdhyk

I am trying to display all the values in an object but it give me 'must be declared' error.

I tried the code below but still giving me same error.

declare

      outN mytype;

begin

      outN:= get_data();

      dbms_output.put_line(outN.toString);

      -- tried this as well

      dbms_output.put_line(outN.ID);

      dbms_output.put_line(outN.G);

      dbms_output.put_line(outN.GES);

      dbms_output.put_line(outN.CC);

      dbms_output.put_line(outN.RR);



end;

And my object is:

 create or replace TYPE           "mytype"

    AS OBJECT

    (

        "ID" NUMBER(10),

        "G" NUMBER(10),

        "GES"  VARCHAR(100 BYTE),

        "CC" NUMBER(10),

        "RR" VARCHAR(100 BYTE)

    );

Errors:

Error report -
ORA-06550: line 5, column 38:
PLS-00302: component 'ID' must be declared
ORA-06550: line 5, column 7:
PL/SQL: Statement ignored
ORA-06550: line 6, column 38:
PLS-00302: component 'G' must be declared
ORA-06550: line 6, column 7:
PL/SQL: Statement ignored
ORA-06550: line 7, column 38:
PLS-00302: component 'GES' must be declared
ORA-06550: line 7, column 7:
PL/SQL: Statement ignored
ORA-06550: line 8, column 38:
PLS-00302: component 'CC' must be declared
ORA-06550: line 8, column 7:
PL/SQL: Statement ignored
ORA-06550: line 9, column 38:
PLS-00302: component 'RR' must be declared
ORA-06550: line 9, column 7:
PL/SQL: Statement ignored
06550. 00000 - "line %s, column %s:n%s"
*Cause: Usually a PL/SQL compilation error.

Another one:

Error report -
ORA-06550: line 5, column 38:
PLS-00302: component 'TOSTRING' must be declared
ORA-06550: line 5, column 7:
PL/SQL: Statement ignored
06550. 00000 - "line %s, column %s:n%s"
*Cause: Usually a PL/SQL compilation error.
*Action:

get_data is just a function that return the result of a select statement (returns db rows)

Not sure what get_data() and toString are in your code. But, this should explain how object values can be displayed.

create or replace TYPE  mytype -- removed double quotes

    AS OBJECT

    (

        "ID"   NUMBER(10),

        "G"    NUMBER(10),

        "GES"  VARCHAR2(100 BYTE), --Use VARCHAR2 instead of VARCHAR

        "CC"   NUMBER(10),

        "RR"   VARCHAR2(100 BYTE)

    );

    /

SET SERVEROUTPUT ON    

DECLARE

     outn   mytype := mytype(1,10,'GES1',20,'RR1'); --declaration and assignment

BEGIN

     dbms_output.put_line(outn.id);

     dbms_output.put_line(outn.g);

     dbms_output.put_line(outn.ges);

     dbms_output.put_line(outn.cc);

     dbms_output.put_line(outn.rr);

END;

/

Result

Type MYTYPE compiled



1

10

GES1

20

RR1





PL/SQL procedure successfully completed.