I'm using Oracle 7.3 and trying to write a stored procedure but I'm getting errors...
What I want to do is build a SQL statement in a string and then run the
string. I know I've done this before using the EXEC command, but Oracle 7
seems to reject it. I have 3 of these to build, (1 SELECT, 1 UPDATE and 1
INSERT). I tried..

EXEC SQL myString;
EXEC SQL EXECUTE myString;
EXECUTE myString;
EXECUTE(mySting);
EXECTUE IMMEDIATE myString;
dbms_SQL.EXECUTE(myString);

... and any other combination I could think of! What am I doing wrong?

Tanya