24x7 always supported PL/SQL blocks. I guess the problem you have is not caused by DatabaseExecute but to how you code this command on multiple lines in other words you have script syntax error. Example (invalid syntax):
DatabaseExecute("begin
line 1;
line 2;
line 3;
end;", rows_affected); Example 1 (valid syntax):
DatabaseExecute("begin line 1; line 2; line 3; end;", rows_affected); Example 2 (valid syntax):
DatabaseExecute("begin &
line 1; &
line 2; &
line 3; &
end;", rows_affected); : Hi,
: I want to execute a block of plsql code that normally I would write on many
: lines in a text editor.
: However with 24x7 I have found in the past I have had to put every line on
: one line in 24x7. : eg: instead of: databaseexecute("begin
: line 1;
: line 2;
: line 3;
: end;", rows_affected); : I have to do databaseexecute("begin line 1; line 2; line 3; end;",
: row_affected); : Do you know now if it is possible to use database execute over a number of
: lines or do I still have to put the commands all on one line?
: It's just that it makes it harder to maintain the code when it is on a vary
: long line.
: Cheers
|
