4 Replies Latest reply on Feb 18, 2014 9:40 AM by sanjeev.gour

Running anonymous procedure blocks from JDBC Client

sanjeev.gour Feb 17, 2014 7:41 AM

Hello-

Looking at the syntax to execute anonymous procedure blocks given here DML Commands - Teiid 8.6 - Project Documentation Editor, I tried the following from the SQuirrel SQL client-

begin insert into actions.rule_state values(now(), 'p','o','match'); end;

It results in the following error-

Error: Remote org.teiid.api.exception.query.QueryParserException: TEIID31100 Parsing error: Encountered ",'match')[*]" at line 1, column 67.

SQLState: 50000

ErrorCode: 0

Error occured in:

begin insert into actions.rule_state values(now(), 'p','o','match')

Am I doing something fundamental wrong?

1. Re: Running anonymous procedure blocks from JDBC Client

shawkins Feb 17, 2014 8:02 AM (in response to sanjeev.gour)

Just make sure you are targeting an appropriate server version. You'll need 8.5 or later.

Steve
Actions
2. Re: Running anonymous procedure blocks from JDBC Client

sanjeev.gour Feb 18, 2014 5:11 AM (in response to shawkins)

The version looks correct, I have verified it against both 8.5 and 8.6. I get the same error with both the versions.
Actions
3. Re: Running anonymous procedure blocks from JDBC Client

shawkins Feb 18, 2014 7:18 AM (in response to sanjeev.gour)

From the error message it appears that SQuirrel is to blame. It must be preprocessing the sql and assuming that it's two statements separated by ;. There may be other workarounds, but you can try changing or removing the SQuirrel Session SQL property for the statement separator.

Steve
Actions
4. Re: Running anonymous procedure blocks from JDBC Client

sanjeev.gour Feb 18, 2014 9:40 AM (in response to shawkins)

That was the problem, I changed it to semi-colon for that session and it works now .

Thank you, Steve.
Actions