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

Home -> Community -> Usenet -> c.d.o.server -> Re: parameters in dbms_sql.define_column

Re: parameters in dbms_sql.define_column

From: Steve Cosner <stevec_at_zimmer.csufresno.edu>
Date: 1998/04/14
Message-ID: <6gusli$jqq2@hendrix.csufresno.edu>#1/1 







In article <35322EB4.1A5591FA_at_juno.com>, James Sim  <jim-sim_at_juno.com> wrote:


>One of the parameters for dbms_sql.define_column() is length, an

>integer. All of the variables I

>am associating to my cursor are defined as %TYPE... Is there any way I

>can avoid hard coding this length into this procedure call?




Write a function to retrieve the length of the column from the
user_tab_columns view.
Received on Tue Apr 14 1998 - 00:00:00 CDT












Original text of this message













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