Dynamic SQL Pb

From: Laurent PISSARD <Laurent.Pissard_at_mc2.fr>
Date: 1997/09/03
Message-ID: <340D54FE.99EE1D42@mc2.fr>#1/1

Hi,

I am doing a "SELECT" on five columns and only 2 columns are accept by the compler :
If someone have an idea of my Pb, Thanks a lot.

My Procedure Body :

---

      curseur := DBMS_SQL.OPEN_CURSOR;

      DBMS_SQL.PARSE (curseur,
                     'SELECT gd_nid, gd_nidpath, gd_name, gd_itemtype,
gd_encode
                      FROM cognaq_gd_items
                      WHERE ' || p_requete,
                      DBMS_SQL.V7 );

      DBMS_SQL.DEFINE_COLUMN (curseur, 1, nid);
      DBMS_SQL.DEFINE_COLUMN (curseur, 2, nidpath);
      DBMS_SQL.DEFINE_COLUMN (curseur, 3, name);
      DBMS_SQL.DEFINE_COLUMN (curseur, 4, itemtype);
      DBMS_SQL.DEFINE_COLUMN (curseur, 5, encode);

      nb := DBMS_SQL.EXECUTE (curseur);

      WHILE DBMS_SQL.FETCH_ROWS (curseur) > 0 LOOP

            DBMS_SQL.COLUMN_VALUE (curseur, 1, nid);
            DBMS_SQL.COLUMN_VALUE (curseur, 2, nidpath);
            DBMS_SQL.COLUMN_VALUE (curseur, 3, name);
            DBMS_SQL.COLUMN_VALUE (curseur, 4, itemtype);
            DBMS_SQL.COLUMN_VALUE (curseur, 5, encode);

           affichage.folderItem ( nid, nidpath, name, itemtype, encode);

      END LOOP;

      DBMS_SQL.CLOSE_CURSOR (curseur);

Oracle Message :

---

SQL> @privrec3.sql

Warning: Package Body created with compilation errors.

Errors for PACKAGE BODY GDWEB_RECHERCHE:

LINE/COL ERROR

---

---

191/7 PLS-00307: trop de déclarations de 'DEFINE_COLUMN' correspondent

         à cet appel

191/7 PL/SQL: Statement ignored
192/7 PLS-00307: trop de déclarations de 'DEFINE_COLUMN' correspondent

         à cet appel

192/7 PL/SQL: Statement ignored
194/7 PLS-00307: trop de déclarations de 'DEFINE_COLUMN' correspondent

         à cet appel

LINE/COL ERROR

---

---

194/7 PL/SQL: Statement ignored

---

If I mask the column 2,3 & 5,
The procedure runs !!

Thanks again,
Laurent PISSARD Received on Wed Sep 03 1997 - 00:00:00 CDT