Replies: 2 comments
-
Can you share more code, including the SQL to create the function? |
Beta Was this translation helpful? Give feedback.
0 replies
-
The documentation shows that the second parameter should be a type (the return type of the function) but your example doesn't show that -- which would explain the error! If that hint doesn't help, please provide the additional information requested by @cjbj. |
Beta Was this translation helpful? Give feedback.
0 replies
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
Uh oh!
There was an error while loading. Please reload this page.
-
I am trying to execute the stored procedure using oracledb module. To start with I had set up a connection by creating dsn object for the database and created a cursor.
dsn = oracledb.makedsn(host, 1521, dbname)
connection = oracledb.connect(user="xxx", password="yyy", dsn=dsn)
cursor = connection.cursor()
cursor.callfunc('%function_name%',('%val%', '%val%', '%val%'))
when I do so I am receiving the following error whereas I am manually able to run the procedure.
oracledb.exceptions.ProgrammingError: DPY-2007: expected a type
Beta Was this translation helpful? Give feedback.
All reactions