You’re offline. This is a read only version of the page.
Hi,
I am trying to call a Oracle Stored procedure from Microsoft flow, but keep getting below error. I tried creating a dummy procedure with no paramters and not much code inside, still getting same error. I tried calling other existing procedure in database which is working and still getting same error whichever procedure I call.
I was able to call stored procedure in my trial version before in my personal laptop's database and I dont think this issue is due to specific error in procedure, since same error is thrown for all procedure.
Can you somoene please assist with this error?
{
"status": 400,
"message": "Oracle: ORA-06550: line 1, column 6:\nPLS-00103: Encountered the symbol \"\" when expecting one of the following:\n\n begin case declare exit for goto if loop mod null pragma\n raise return select update while with <an identifier>\n <a double-quoted delimited-identifier> <a bind variable> <<\n close current delete fetch lock insert open rollback\n savepoint set sql execute commit forall merge pipe\nThe symbol \"\" was ignored.\nORA-06550: line 2, column 36:\nPLS-00103: Encountered the symbol \"\" when expecting one of the following:\n\n begin case declare end exception exit for goto if loop mod\n null pragma raise return select update while with\n <an identifier> <a double-quoted delimited-id\r\n inner exception: Oracle: ORA-06550: line 1, column 6:\nPLS-00103: Encountered the symbol \"\" when expecting one of the following:\n\n begin case declare exit for goto if loop mod null pragma\n raise return select update while with <an identifier>\n <a double-quoted delimited-identifier> <a bind variable> <<\n close current delete fetch lock insert open rollback\n savepoint set sql execute commit forall merge pipe\nThe symbol \"\" was ignored.\nORA-06550: line 2, column 36:\nPLS-00103: Encountered the symbol \"\" when expecting one of the following:\n\n begin case declare end exception exit for goto if loop mod\n null pragma raise return select update while with\n <an identifier> <a double-quoted delimited-id\r\nclientRequestId: d7522ac6-3934-4bf9-9052-660c24660ed7",
"source": "oracle-eus.azconn-eus.p.azurewebsites.net"
}
Did you ever find out what the cause was? We are currently seeing the same issue under the same scenario:
- Error message also specifies "" (empty string) as the unsupported character
- Also only appears in Oracle 9, not in other versions of Oracle and not in SQLDeveloper against any version
On further testing, this is an issue with connecting to older version of Oracle. The issue I faced is with Oracle 10g. No matter which procedure I called, same error is returning. So there is some settings or calling style which is causing this issue. Not sure if there is any solution to this.
I tried calling a procedure from Oracle 12C and it is working without any issues.
Hi @v-yamao-msft,
That was my first thought, but this character is not present in the procedure. Also same error is being thrown for any procedure which I use from flow, but it is working fine when I execute the procedure directly from Toad. I think the issue is not with the procedure. I tested by creating a dummy procedure as below, this is very simple one with no logic. I still get the same error when I call it from flow.
create or replace procedure generate_errors_test
is
begin
null;
end;
Hi @Anonymous,
I am afraid there is an unexpected character in your code.
When you create the Stored procedure, have you used the escape character (“\”)?
Please take this doc on Oracle Database for a reference:
https://docs.microsoft.com/en-us/connectors/oracle/
Best regards,
Mabel Mao
#1
WarrenBelz
146,660
Most Valuable Professional
#2
RandyHayes
76,287
Super User 2024 Season 1
#3
Pstork1
66,004
Most Valuable Professional
Share
Report
All responses (
Answers (