Oracle database connector - Insert raw with Oracle DB

(0) Share

Report

Posted on by June_Cho

Hello,

I am trying to insert raw to by Oracle database.

Microsoft PowerApps Plan 1 is alreay assigned to me.

- I can add 'Insert raw' action from Oracle connect at Flow

- I can browse the list of table properly at selecting table name box

- When i select a table, below error message is displayed on top of selecting table name box

"Oracle: ORA-00933: SQL command not properly ended inner exception: Oracle: ORA-00933: SQL command not properly ended clientRequestId: 7436503C-A60B-4631-BB82-4C95914D4956"

- To configure properly, detail input box should be apeared below selecting table name box. But, it didn't displayed.

I have enough previllage to Oracle DB. And, I can insert some raw using other query tools.

From my guess, there is no problem to access to Oracle DB itself. (I can see the list of table properly)

But, some internal query/API of Flow to obtain schema of specific table causing this error.

How do you think about it?

Categories:

Using connectors

All responses (4)

Answers (0)

Sort by

v-yamao-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @June_Cho ,

It seems that all the tables are displayed properly, however, error message “SQL command not properly ended inner exception” returned when you select a table.

Does this error only occur when you select a specific table?

Per my certain research, I found that this error is caused by an SQL statement with a clause that is not allowed for that statement.

Here is a blog on how to resolve this issue:

https://www.databasestar.com/ora-00933/

Please check and update your statement then try again with it.

Best regards,

Mabel
June_Cho 4 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @v-yamao-msft ,
Thanks for your replay. I got same error for all other tables.
About query, I can't edit it by self. Because, it should be internal query to obtain schema of table at Oracle Connector.
Thanks,
June
v-yamao-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @June_Cho ,

Thanks for updating.

Are you trying to use native Oracle query?

If so, Oracle native query is not supported.

Please check the known issues and limitations at here:

https://docs.microsoft.com/en-us/connectors/oracle/#known-issues-and-limitations

Best regards,

Mabel
June_Cho 4 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @v-yamao-msft ,
I didn't try to use native Oracle query in Flow. Could you let me know how to do it?
But, I can get and insert rows through other query tool well.

And, I checked above the known issues and limitations. These are not relevant with my case.
Thanks,
June