Skip to main content
Community site session details

Community site session details

Session Id :
Power Automate - Using Connectors
Unanswered

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

(0) ShareShare
ReportReport
Posted on by

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

  • twolverson Profile Picture
    2 on at
    Re: Oracle stored procedure -PLS-00103: Encountered the symbol \"\"

    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

  • Community Power Platform Member Profile Picture
    on at
    Re: Oracle stored procedure -PLS-00103: Encountered the symbol \"\"

    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.

  • Community Power Platform Member Profile Picture
    on at
    Re: Oracle stored procedure -PLS-00103: Encountered the symbol \"\"

    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;

  • v-yamao-msft Profile Picture
    on at
    Re: Oracle stored procedure -PLS-00103: Encountered the symbol \"\"

    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

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

Paul Stork – Community Spotlight

We are honored to recognize Paul Stork as our July 2025 Community…

Congratulations to the June Top 10 Community Leaders!

These are the community rock stars!

Announcing the Engage with the Community forum!

This forum is your space to connect, share, and grow!

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 497 Super User 2025 Season 1

#2
David_MA Profile Picture

David_MA 436 Super User 2025 Season 1

#3
Riyaz_riz11 Profile Picture

Riyaz_riz11 244 Super User 2025 Season 1

Featured topics