web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / Oracle stored procedur...
Power Automate
Unanswered

Oracle stored procedure -PLS-00103: Encountered the symbol \"\"

(0) ShareShare
ReportReport
Posted on by Microsoft Employee

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"
}

Categories:
I have the same question (0)
  • v-yamao-msft Profile Picture
    Microsoft Employee on at

    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

  • Community Power Platform Member Profile Picture
    Microsoft Employee on at

    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;

  • Community Power Platform Member Profile Picture
    Microsoft Employee on at

    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.

  • twolverson Profile Picture
    2 on at

    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

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Users!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Congratulations to the March Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Automate

#1
Haque Profile Picture

Haque 592

#2
Valantis Profile Picture

Valantis 340

#3
11manish Profile Picture

11manish 284

Last 30 days Overall leaderboard