Dynamic SQL in Stored procudures

[henrik mahlberg]

Hi

I want to create dynamic SQL in stored procedures. Is that not supported?

I tried a very simple test and couldn't get i working:
DECLARE X VARCHAR (199);
SET X = 'INSERT INTO LOGG SELECT PFILE_Filename FROM PFILE_FILE';
??? X

I tried with Execute X......

Another question. Is it possible to invoke LOAD DATA INFILE.. within a Stored procedure, I couldn't get that working either.


/Henrik Mahlberg