With cx_Oracle module
Using cur. Execute the submission of SQL (SQL)
Execute the select and insert into no problem
But I will write in the pl/SQL create view statement in cur. Execute (' create view statement) to implement after the show success, as the chart
But with a pl/SQL query this view is prompt has not created, is in fact is not to create success,
This is how to return a responsibility excuse me?
What's the solution?

CodePudding user response:

Have a great god help look at it

CodePudding user response:

In the python build view permissions login user?

In python in the login user name password, login to pl/SQL, execution of the create view statement, see if I can succeed,

CodePudding user response:

refer to the second floor old coconut response:

login in python build view permissions users?

In python in the login user name password, login to pl/SQL, execution of the create view statement, see if I can success,

doesn't work

CodePudding user response:

reference ykk1106 reply: 3/f

Quote: refer to the second floor of the old coconut reply:

login in python build view permissions users?

In python in the login user name password, login to pl/SQL, execution of the create view statement, see if I can success,

not

I call a stored procedure in python and then create the view