Using bind variables to temporarily store data

[AndreasAuer]

Hi

my problem is the following:
I have to create a report with Centura Report Builder which is very long. To be able to store the Statements (cause its longe than 2000 chars), I want to store Information in a variable like select column1, column2 into var1,var2 from table.

how can I do this??

 

[Scunningham99]

Im i right in assuming you wish to insert a full select statement in to a variable. if so you could do something like



v_select1 := 'Select col1, col2 from table1 where col1 = ''Michael'' ';

Obviously, v_select varchar2(??) datatype

dont know if this is what u r looking for???