DECLARE TYPE table_type_1 IS TABLE OF NUMBER(10); TYPE table_type_2 IS TABLE OF NUMBER(10); v_tab_1 table_type_1; v_tab_2 table_type_2; BEGIN -- Initialise the collection with two values. v_tab_1 := table_type_1(1, 2); -- Assignment causes compilation error. v_tab_2 := v_tab_1; END; / v_tab_2 := v_tab_1; * ERROR at line 11: ORA-06550: line 11, column 14: PLS-00382: expression is of wrong type ORA-06550: line 11, column 3: PL/SQL: Statement ignored SQL>
Pages
- Home
- SQL Fundamentals
- SQL Fundamentals II
- SQL PLUS
- PL/SQL
- Forms and Reports
- HTML5
- JavaScript
- PHP
- jQuery
- Java
- NLS_LANG
- SQL SERVER
- PL/SQL Collections and Records
- DBMS_OUTPUT built-in package
- Date and Time
- PL/SQL Transactions
- Ref Cursors
- Bulk Binds
- PL/SQL Analytic Functions
- Problems and solves
- Oracle Indexes
- Oracle Courses
- PHP
- Work Samples
- Record & Collection
- LOOP
- Conditional statements
- Triggers
- Object Oriented
- Contact Me
Tuesday, October 20, 2015
Oracle collection error for assign variable of table to another
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment