HI!

I am a little brain dead today...
How can I pass this parameter p_mainkey to this function

OR do something like

'select * from assortm where mainkey='||"'"||p_mainkey||"'"

INTEGRATION.SQLTOFILE('select * from assortm where mainkey=p_mainkey');

Here is the code:

create or replace procedure TEST(p_mainkey in varchar2)
as
l_rows number;
begin
l_rows := INTEGRATION.SQLTOFILE( 'select * from assortm where mainkey='||"'"||p_mainkey||"'", ';', 'C:\temp\', 'assortm.dat' );
end;
/