Entire Site
Free Trial
Safari Books Online is a digital library providing on-demand subscription access to thousands of learning resources.
- Create BookmarkCreate Bookmark
- Create Note or TagCreate Note or Tag
- PrintPrint
Section 9: Using Collections > Solutions - Pg. 220
Oracle9i Advanced PL/SQL Programming Page 220 Solutions COLLECTION-1 SET SERVEROUTPUT ON; CREATE OR REPLACE PROCEDURE bulk_bind ( ColumnChar VARCHAR2, ColumnNumber VARCHAR2, TableName VARCHAR2 ) AS TYPE varrayChar IS VARRAY(30) OF VARCHAR2(20); TYPE varrayNumber IS VARRAY(30) OF NUMBER; c1 c2 varrayChar; varrayNumber; SYS_REFCURSOR; VARCHAR2(1000); dbCursor sql_statement BEGIN
