cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
itsgowthaman
Level: Powered On

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

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

3 REPLIES 3
Community Support Team
Community Support Team

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

Hi @itsgowthaman,

 

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 Support Team _ Mabel Mao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
itsgowthaman
Level: Powered On

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;

Highlighted
itsgowthaman
Level: Powered On

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.

Helpful resources

Announcements
firstImage

Incoming: New and improved badges!

Look out for new contribution recognition badges coming SOON!

firstImage

Power Platform Online Conference

Join us for the first ever Power Platform Online Conference!

firstImage

New & Improved Power Automate Community Cookbook

We've updated and improved the layout and uploading format of the Power Automate Cookbook!

thirdimage

Power Automate Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

fifthimage

Microsoft Learn

Learn how to build the business apps that you need.

sixthImage

Power Platform World Tour

Find out where you can attend!

seventhimage

Webinars & Video Gallery

Watch & learn from the Power Automate Community Video Gallery!

Users online (5,852)