Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Dynamic SQL Pb
> 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