Oracle PL/SQL statements with carriage returns

edited March 2012
This is using the latest v4 beta.

I'm trying to run some pl/sql statements (using language: sql) in linqpad and getting errors. I can run simple select statements and they work fine, but when I try to run statements that include the declaring of variables, looping, etc. I get errors back about the first line of my statement - apparently the carriage returns are causing problems. Here's a sample error message:

ORA-06550: line 1, column 8:
PLS-00103: Encountered the symbol "" when expecting one of the following:

begin function package pragma procedure subtype type use
form
current cursor

line 1 column 8 is right after a declare command, at a carriage return. If I concatenate my whole statement into a single line and run just that line it will run.

Simple select statements with from's and where's will work fine with carriage returns, so there may be something going on when things like declares are used that is causing problems.

Comments

  • I've updated the latest beta to strip character 13s from the output (apparently it can cause this error). Try and let me know: www.linqpad.net/beta.aspx
  • That appears to have fixed the problem. Thanks.
Sign In or Register to comment.

Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!