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

Notifications

Announcements

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

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

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 538 Super User 2025 Season 2

#2
Tomac Profile Picture

Tomac 405 Moderator

#3
abm abm Profile Picture

abm abm 252 Most Valuable Professional

Last 30 days Overall leaderboard