LAE

Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

Originally posted by: saravan

Hi,

When i try to execute the following plsql query in sqlrunner node from the lavastorm graph, i'm getting the "PLS-00103: Encountered the symbol "" when expecting one of the following:" errors. Can anyone help me on this issue?

Included the error log details below in RED.

"DECLARE
i number;
retVal varchar2(1024);
attachment_id number;
BEGIN
SELECT COUNT(*) INTO i FROM tempblob;
WHILE i > 0
LOOP
SELECT attachment_id INTO attachment_id FROM tempblob WHERE id =i;
retVal := FN_WRITE_BLOB_TO_FILE(attachment_id);
i := i -1;
END LOOP;
DELETE FROM ATTACHMENT WHERE attachment_id IN (SELECT attachment_id FROM tempblob);
END;"


ERROR Log details:
=================

2012-01-03 17:33:41; Level: 2; Type: 0; Desc: "OCI Error 6550: ORA-06550: line 1, column 1:
PLS-00103: Encountered the symbol "" when expecting one of the following:

begin case declare exit for function goto if loop mod null
package pragma procedure raise return select separate type
update while with <an identifier>
<a double-quoted delimited-identifier> <a bind variable> <<
form table call close current define delete fetch lock insert
open rollback savepoint set sql execute commit forall merge
library OPERATOR_ <a single-quoted SQL string> pipe
"; File: "./../../jigsaw/Code/Source/Oci/OciUtils.cpp"; Line: 83; Context: ""
2012-01-03 17:33:41; Level: 2; Type: 0; Desc: "Error executing statement:
DECLARE
i number;
retVal varchar2(1024);
attachment_id number;
BEGIN
SELECT COUNT(*) INTO i FROM tempblob;
WHILE i > 0
LOOP
SELECT attachment_id INTO attachment_id FROM tempblob WHERE id =i;
retVal := FN_WRITE_BLOB_TO_FILE(attachment_id);
i := i -1;
END LOOP;
DELETE FROM ATTACHMENT WHERE attachment_id IN (SELECT attachment_id FROM tempblob);
END;
. On connection: lvs_schema@LAVAS1BD. ORA-06550: line 1, column 1:
PLS-00103: Encountered the symbol "" when expecting one of the following:

Thanks in advance,
Saravan.

Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

Originally posted by: rboccuzzi

I'm not sure, but if you want to post the node, we might be able to help. I noticed that you have a column and variable named the same (attachment_id) which might also be a problem, but not sure if it is this particular problem.

Cheers
Rich

Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

Originally posted by: saravan

Hi Rich,

Please find the attached node.

Thanks,
Saravan
Attachments:
Write Blob to file.brg

Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

Originally posted by: saravan

Hi,

When I have tried to execute a lavastorm node (Sqlrunner node) which contains the below PL/SQL block, It is working fine in BRE tool, but it is giving error when executing the same corresponding �brx� file in Unix environment.

I'm getting the "PLS-00103: Encountered the symbol "" when expecting one of the following:" errors.

Included the error log details below in RED.

"DECLARE
i number;
retVal varchar2(1024);
attachment_id number;
BEGIN
SELECT COUNT(*) INTO i FROM tempblob;
WHILE i > 0
LOOP
SELECT attachment_id INTO attachment_id FROM tempblob WHERE id =i;
retVal := FN_WRITE_BLOB_TO_FILE(attachment_id);
i := i -1;
END LOOP;
DELETE FROM ATTACHMENT WHERE attachment_id IN (SELECT attachment_id FROM tempblob);
END;"


ERROR Log details:
=================

2012-01-03 17:33:41; Level: 2; Type: 0; Desc: "OCI Error 6550: ORA-06550: line 1, column 1:
PLS-00103: Encountered the symbol "" when expecting one of the following:

begin case declare exit for function goto if loop mod null
package pragma procedure raise return select separate type
update while with <an identifier>
<a double-quoted delimited-identifier> <a bind variable> <<
form table call close current define delete fetch lock insert
open rollback savepoint set sql execute commit forall merge
library OPERATOR_ <a single-quoted SQL string> pipe
"; File: "./../../jigsaw/Code/Source/Oci/OciUtils.cpp"; Line: 83; Context: ""
2012-01-03 17:33:41; Level: 2; Type: 0; Desc: "Error executing statement:
DECLARE
i number;
retVal varchar2(1024);
attachment_id number;
BEGIN
SELECT COUNT(*) INTO i FROM tempblob;
WHILE i > 0
LOOP
SELECT attachment_id INTO attachment_id FROM tempblob WHERE id =i;
retVal := FN_WRITE_BLOB_TO_FILE(attachment_id);
i := i -1;
END LOOP;
DELETE FROM ATTACHMENT WHERE attachment_id IN (SELECT attachment_id FROM tempblob);
END;
. On connection: lvs_schema@LAVAS1BD. ORA-06550: line 1, column 1:
PLS-00103: Encountered the symbol "" when expecting one of the following:

Do you have any idea on the cause of this issue ?

Please find the sample node attached.

Thanks in advance,
Saravan

Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

Originally posted by: timonk

Saravan,

Good Day. This issue looks to be more of a Support level situation. I would recommend you contact

Technical Support

And open a full ticket. Provide full information on any steps you have taken thus far to resolve it on your own. One of the Support Team will take charge of it and contact you.

Regards,
Timon Koufopoulos
MDS Lavastorm Support.