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