Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Dynamic SQL Pb

Re: Dynamic SQL Pb

From: Steven Whatley <swhatley_at_blkbox.com>
Date: 1997/09/21
Message-ID: <601sht$4a7@news.blkbox.com>#1/1

> 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);

My guess is that nidpath, name and encode are varchar2. In this case define_column requires a 4th parameter indicating the length of the Varchar2 field.

Later,
Steven
http://www.blkbox.com/~swhatley/

                      _|_  |  _|_   "I am the way and the truth and
Steven Whatley         | --|-- |    the life.  No one comes to the
swhatley_at_blkbox.com    |   |   |    Father except through me."
Houston, Texas             |            -- Jesus Christ (John 14:6 NIV)
                           |
Received on Sun Sep 21 1997 - 00:00:00 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US