EXECUTE IMMEDIATE - What's wrong ?
Posted in 1995
Hi everybody, I've RTFM and there I've found something like this : ** MANUAL ** QUICK EXECUTION For simple statements thet do not require a cursor or host variables, you can combine the actions of the PREPARE, the EXECUTE, and the FREE statements into a single operation. The EXECUTE IMMEDIATE statement takes a character string and in one operation prepares it, executes it, and frees the storage. -------------------------------------------------------- $ EXECUTE IMMEDIATE "drop index my_temp_index"; -------------------------------------------------------- ************ So I tried it and the result was this : ** 4gl ** execute immediate "delete from my_temp_table" | The cursor "immediate" has not yet been declare in this | program ... ********** Release : Manual = version 4.10 RDS = version 4.1 4GL = version 4.1 So WHAT'S WRONG WITH IT ? Thank You. Rasto -- Rastislav JANAC SOFTEC s. r. o. e-mail: rasto@softec.sk Kutuzovova 23 phone : 42-7-273805 ext.127 831 01 Bratislava fax : 42-7-272537 Slovakia