Odtnhj

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.