Skip to Main Content
  • Questions

  • Bind variables in calls to stored procedures

Breadcrumb

Connor and Chris will both be at AI World from October 12 to October 17 , the premier Oracle conference of 2025. If you're in Vegas, please come say Hi or pop into our sessions

Question and Answer

Connor McDonald

Thanks for the question, Andrew.

Asked: October 08, 2025 - 6:14 am UTC

Last updated: October 09, 2025 - 4:22 am UTC

Version: 19.28.0.0

You Asked

I'm using Oracle 19.28, oracles 3.3.0 and python 3.9.20.
What are the rules for using bind variables (either positional or named) when calling a stored procedure using oracles ?
Additionally where can I find a complete list of DPY error codes from oracles ?

and Connor said...

What are the rules for using bind variables (either positional or named) when calling a stored procedure using oracles ?

Not sure what you mean. Rules?

Binds are covered here https://python-oracledb.readthedocs.io/en/latest/user_guide/bind.html

For errors (thanks to Christopher Jones for these).

Main ones: https://python-oracledb.readthedocs.io/en/latest/user_guide/troubleshooting.html#dpy-error-messages

Complete list

https://github.com/oracle/python-oracledb/blob/main/src/oracledb/errors.py#L561
more

Connor and Chris don't just spend all day on AskTOM. You can also catch regular content via Connor's blog and Chris's blog. Or if video is more your thing, check out Connor's channel and Chris's channel from their Youtube channels. And of course, keep up to date with AskTOM via the official twitter account.

More to Explore

CLOB/BLOB/etc

Complete documentation on Securefiles and Large Objects here