Hi All,
Let me preface this by saying I have a work around. I don't like it because I think it should be able to be done another way but t works.
I created a CRUD SP builder that once you have your data model goes through and builds the generic data maintenance SPs for you. I initially built everything into one huge string (i.e. something like the result you would get using FileToString on a script file). I tried sending that to Oracle via SPT and it would come back with mixed results.
The SQLExec would return okay but the resulting SP would be invalid. The problem being that Oracle would create the SP named in the first "Create or Replace Porcedure" statement and append everything else after it. The result of that is I would get 1 SP instead of 18. I put "/" between each create statement to make Oracle think it is one block.
What I ended up doing is preprocessing the SQL code to see if multiple statements exist. If they do, I use ALines() to break them up into singular SQL statements and send those individually.
Has anyone ever gotten mulitple blocks to run via SPT?
Larry Miller
MCSD
LWMiller3@verizon.netAccumulate learning by study, understand what you learn by questioning. -- Mingjiao