Re: Multiple SQL statements without separators (port from Sybase)

Brian Tkatch wrote:

> Adding semi-colons should help.
>
> Also a '/' is the equivalent of "go".
>
> Brian
>

Thanks, but unfortunately it is nearly impossible to add a semicolon to the end of each statement because my code is passed the entire set of statements as a single string and I would have to try to parse that string into pieces to extract the individual statements and add the semicolons. Writing such a parser to handle all of our possible cases isn't a very exciting prospect. Adding a single semicolon to the end of the whole thing doesn't work either (sql statement not properly terminated or something like that). I am hoping for a solution that would allow Oracle to swallow the string as is or with additions only to the beginning or end of the whole string.

Thanks again,

Brad Lotsberg, EET. Received on Tue May 09 2000 - 00:00:00 CDT