Home » SQL & PL/SQL » SQL & PL/SQL » Dynamic Variables
Dynamic Variables [message #38887] Thu, 23 May 2002 22:56 Go to next message
bharath
Messages: 30
Registered: November 2000
Member
how to define dynamic varibles in dbms_sql.define_column statement which will be executing in a loop based on number of inputs
thanks in advance
bharath

Report message to a moderator

Re: Dynamic Variables [message #38889 is a reply to message #38887] Thu, 23 May 2002 23:32 Go to previous messageGo to next message
oxkar
Messages: 9
Registered: May 2002
Junior Member
I'd use something like that:

StringTab dbms_sql.Varchar2_Table;
NumberTab dbms_sql.Number_Table;
DateTab dbms_sql.Date_Table;

Then you'd type something like:

FOR i IN 1..i LOOP
IF data_type = 0 THEN
dbms_sql.define_column(source_cursor, i, StringTab(i),50);
ELSIF data_type = 1 THEN
dbms_sql.define_column(source_cursor, i, NumberTab(i));
ELSIF data_type = 2 THEN
dbms_sql.define_column(source_cursor, i, DateTab(i));
END IF;
END LOOP;

Hope this helps.

Report message to a moderator

Re: Dynamic Variables [message #39709 is a reply to message #38889] Fri, 02 August 2002 14:33 Go to previous message
Dinesh
Messages: 31
Registered: October 2001
Member
Then how would you
use bind_variable and then use the column_value steps ?

Thanks

Dinesh

Report message to a moderator

Previous Topic: OUT Parameters
Next Topic: Problem while creating SEQUENCE from PL/SQL
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Thu Apr 25 21:50:23 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.