How to execute oracle pl-sql blocks on Relativity

Data Abstract
1

Hi,

Below is the plsql block that I would like to run as a command on Relativity.

begin
update foo set some_field = ‘some data’ where id =1;
update bar set some_field = ‘some data’ where id =1;
end;

I got the following error message;

“ORA-06650: line 1, column 6: PLS-00103: Encountered th symbol “” when expecting one of the following: …”

I’ve tested this issue with different oracle drivers. With Oracle.Net and ODP.Net drivers I got same error message. But, It works perfect with Oracle OLEDB driver.

Regards
Davut

2

Hello Davut.

Sorry for the belated response.
Unfortunately, I can’t reproduce the problem. The provided pl/sql block works fine if it is defined as command. Can you send us small testcase with the problem or more detailed step-by-step instructions to investigate the problem in details?

Thanks in advance.

3

Hello

I attached a zip file contains DA schema and connection files. I use Oracle10g Express Edition and sample HR database user.

I provided three different oracle connection (ODP.NET,Oracle.Net,OLEDB) and a command called as "BatchInsert’.You can see the proplem as click “run as command” button in the sql editor with Oracle_NET and Oracle_ODP statements in the Da Schema Modler. The Oracle_OLEDB statement runs as expected.

Please note I encounter same exception when I deploy the schema to Relativity Server and access from delphi.

Here is my environment;

OS: Win 7 64 bit
DA version: 6.0.57.993

Regards
Davut

4

Hello Davut.

Thank you for the testcase and instructions. I have reproduced the problem. Appropriate issue is registered as #55655 “Encountered the symbol “” when expecting one of the following …” exception if execute PL/SQL block".

Thanks.

5

This is most likely caused by a #13.

Oracle hates that (it is not a whitespace).

Put it in one line until someone found a way to either wrap the Oracle driver or tell the ODP to fix all #13.