I need to create/modify stored procedures in Oracle, but I get an exception whenever I try.
ORA-0900: invalid SQL statement
and
ORA-06550: line 1, column 6:
PLS-00103: Encountered the symbol "" when expecting one of the following:
<followed by a bunch of keywords>
I believe that this is because the parser is breaking the PL/SQL stored procedure into smaller pieces wherever it sees a semi-colon, rather than executing the whole string in one go.
I had the same problem with Squirrel SQL, but a later version fixed this. However I'd really like to use SQL Explorer if at all possible. I understand that SQL Explorer makes use of the Squirrel SQL internals. Are there any plans to use these "latest internals"?
Regards,
Rogan
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Hi folks,
I need to create/modify stored procedures in Oracle, but I get an exception whenever I try.
ORA-0900: invalid SQL statement
and
ORA-06550: line 1, column 6:
PLS-00103: Encountered the symbol "" when expecting one of the following:
<followed by a bunch of keywords>
I believe that this is because the parser is breaking the PL/SQL stored procedure into smaller pieces wherever it sees a semi-colon, rather than executing the whole string in one go.
I had the same problem with Squirrel SQL, but a later version fixed this. However I'd really like to use SQL Explorer if at all possible. I understand that SQL Explorer makes use of the Squirrel SQL internals. Are there any plans to use these "latest internals"?
Regards,
Rogan